Thread: Count with multiple criterias
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Count with multiple criterias
Hi,

Mike is right ...
But you seem to have three and not two criteria :

=SUMPRODUCT((A2:A6=40)*(B2:B6=1)*(C2:C6="A")

HTH
Carim
Reply With QuoteReply With Quote