hi,

I have a file and would like to use the sum if formula (i think) to look for a large amount of criteria, based on a range.

for example, if sheet2 has a (2 column) table that lists different foods (col. A) vs. quantities (col. B), such as:

Apple (2)
Meat (2)
Orange (4)
Crackers (5)
Grape (6)
Banana (10)
. . .

and a separate sheet in the file has a field for "Fruits", with a field next to it that would show the sum of all the fruit quantities in sheet1, how do I do it? I don't want to use the "AND" function, because what I I have 20+ fruits.

is there a way to use the sum if function to look up all criteria in a one-column range (listing all the fruits that show up in sheet2)?
thank you
(sorry if i was unclear)