Multiple Criteria

D

Dane

This is probably a simple question but I just can't
figure out the array formula to do a SUM if two criteria
are met.

Here is an example of what I am trying to do:
Apple Fruit 50
Orange Fruit 65
Apple Red 45
Apple Fruit 50
Orange Fruit 65
Apple Red 45

I want to SUM the third column only if column A is =
to "Apple" and column B = "Fruit"

So far I think I need to use a combination of the COUNTIF
and SUMIF functions but can't get them to work correctly.

TAI
 
J

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100="Fruit"),C1:C100)

If you're interested in Orange Fruits and Apple Reds as well, I'd highly
recommend using a Pivot Table instead.
 
Top