Thread: SumIf + And
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Idolminder Idolminder is offline
external usenet poster
 
Posts: 3
Default SumIf + And

I want to draw out information from a table of fields if two conditions are
true. SumIF doesn't seem to handle it, but I may be using it incorrectly.

A1=products, B1=price, C1=quantity sold, D1=quarter sold in

A2=carrots, $1.00, 20, 4
A3=beets, $2.00, 10, 4
A4=carrots, $1.00, 15, 3
A5=carrots, $1.00, 10, 4

So what I'm trying to get out of this is a sum of the Quantity of carrots
sold during each quarter. To me that's the Sum of quantities, If quarter = 1
and product = carrots - but I'm not sure how to build it...

Thoughts?