howto: sum a data list

[fmazzarelli]

Hi Community,

could you help me?

A table contains these values:

Name                     Number

BOOK 1      ........... 20

BOOK 2 ................. 4

A12345 ...............    34

G45677 .................. 3

901020 ................   34

FRUIT ................. 34

DISK ..................  123

H12497 ..............    3

HowTo sum only:

A12345

G45677

901020

H12487

[sunny_talwar]

Not sure I understand your followup question?

[fmazzarelli]

Hi,

A table contains these values:

Name                     Quantity 1                Quantity2

BOOK 1      ........... 20                                   0

BOOK 2 ................. 4                                    0

A12345 ...............    34                                5

G45677 .................. 3                                  4

901020 ................   34                                5

FRUIT ................. 34                                    0

DISK ..................  123                                  0

H12497 ..............    3                                   3

The formula should be:

1) create a table (table1) containing ONLY values (A12345, G45677, H12497) 

please note that table contains hundreds of values and it's impossibile to list them

2) create a new formula

if Name is equal to one of those present in the table1, (quantity1 + quantity2), quantity1