Multiple Criteria

  • Thread starter Thread starter Dane
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASAP bout pivot table 1
Min-Max question 6
Count the columns from one sheet and paste it in another sheet 0
Drop Down Total Function 1
How to determine the number of types? 5
Counting Occurence of Criteria in Multiple Lists of Data 4
Sorting multiple columns (fields) in a pivot table 1
Returning row headings for values greater than 0 10

Back
Top