Thread: Countif(and
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Countif(and
=SUMPRODUCT(--(A1:A5=M3),--(B1:B5=M4),--(C1:C5<""))
--
David Biddulph

"John" wrote in message
...
I want to count cells in Column C when column A criteria are met and Column
B
criteria are met.
ex. Countif(AND(A1:A5,M3,B1:B5,M4,COUNT(C1:C5)


Reply With QuoteReply With Quote