Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure I understand your followup question?
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