G
gmac
I want to sum all the positive values from a database for a singl
criteria.
e.g. database is,
fruit buy/sell quantity
apples -5
oranges 2
apples 3
apples 1
I want to sum all the positive values only for apples. (Note my rea
database has many more entries than this).
so I am sumif(database, "apples", quantity) which returns -1
what can I do to just get the positive numbers of apples ??
Help Please :
criteria.
e.g. database is,
fruit buy/sell quantity
apples -5
oranges 2
apples 3
apples 1
I want to sum all the positive values only for apples. (Note my rea
database has many more entries than this).
so I am sumif(database, "apples", quantity) which returns -1
what can I do to just get the positive numbers of apples ??
Help Please :