Thread: Sum a column is criteria in two in column and other column are met
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Sum a column is criteria in two in column and other column are met
Hi,

Try this

=sumproduct(('Jan UA'!$C$2:$C$5000="ORD")*('Jan UA'!$P2:$P5000=M3))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" wrote in message
...
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

Reply With QuoteReply With Quote