View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default COUNT IF with multiple conditions

=SUMPRODUCT(--(B2:B20=1),--(C2:C20="A"),--(MONTH(E2:E20)=3))

--
__________________________________
HTH

Bob

"Ghalmaraz" wrote in message
...
Hi,

I need a formula to count the number events that occur BY a certain person
(in column B, with each person numbered from 1-22), IN a certain category
(in
column C, with the events coded as A,B,C and D) AND in a certain month (in
column E, date format ??/??/????)

Any ideas?