try =SUMPRODUCT(--(B1:B20=A1),C1:C20)+SUMPRODUCT(--(B1:B20=A2),C1:C20)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Kristopher" wrote:

Cell A1 has the text "apples" and cell A2 has "oranges". Cells B1:B20 have
the text names of many different fruits, including apples and oranges. Cells
C1:C20 have the prices I paid for each of the different fruits in B1:B20. I
want to add all of the amounts I paid for the apples AND oranges.
SUMIF(B1:B20, A1:A2, C1:C20) doesn't work because SUMIF won't accept a range
for the criteria - I can get a sum for one criteria (apples OR oranges), but
not both.

My real world application of this problem uses 11 different criteria instead
of just two. The criteria may change depending on what text is in the cells,
so I'd really like to just point to the cells these criteria are in and ask
Excel to see if my range matches any of those criteria, not just one of them.

Thanks!