Thread: Sum a column is criteria in two in column and other column are met
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
  
Posts: 2,069
Default Sum a column is criteria in two in column and other column are met
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