Sum a column is criteria in two in column and other column are met

J

John

My formula:
=COUNT(IF(AND('Jan UA'!$C:$C,"ORD",'Jan UA'!$P:$P,M3),COUNT('Jan UA'!$P:$P)))

I want to Count all the cells in column P when column C = ORD and column P =
what is in M3
 
J

Jacob Skaria

Hi John

When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((C1:C1000="ORD")*(P1:p1000=M3))

If you are using Excel 2007 check out help on COUNTIFS()
=COUNTIFS( Criteriarange1,Criteria1,Criteriarange2,Criteria2,...)
 

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

Top