Counting items based on multiple conditions

[John Eakins]

Attached spreadsheet explains the problem

What I need to do would be possible if COUNTIF could be based on mor
than 1 conditio

Attachment filename: query 1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51221

 

[Frank Kabel]

Hi
try something like
=SUMPRODUCT((A1:A100="cond_1")*(B1:B1000="cond_2"))

or as alternative syntax
=SUMPRODUCT(--(A1:A100="cond_1"),--(B1:B1000="cond_2"))

 

[Andy B]

Hi

Try using SUMPRODUCT() like this:
=SUMPRODUCT((D913="JE")*(F9:F13>9)*(F9:F13))
and
=SUMPRODUCT((D913="TG")*(F9:F13>9)*(F9:F13))

Hope this helps