Also, maybe put the fruits in a range and use

=SUMPRODUCT((ISNUMBER(MATCH(A1:A200,L1:L20,0)))*(B 1:B200))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Vinay" wrote in message
...
Prolly a simple question.

I need a way to sumif with multiple CHOICES, not criteria.

In other words something like this ..

=sumif(a1:a200,or("Banana","Lemon"),b1:b200)

Id rather not use the formula twice as I am referencing an external
workbook
and have many "Fruits" to choose from. The formula essentially becomes too
long if I add up too many "Fruits"