One way:

=SUMPRODUCT(--(A1:A100="Orange"), (B1:B100="East")+(B1:B100="West"),
C1:C100)


In article ,
JenniferCHW wrote:

I tried both responses and can't seem to get this to work. Let me be a bit
more specific with a short example.

Col A Col B Col C
Apple West 5
Orange South 7
Orange East 9
Orange West 4

I am looking for oranges in the west or east only. The answer is 13.