View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hansueli Hansueli is offline
external usenet poster
 
Posts: 9
Default COUNT IF with multiple conditions

Sorry, there was an error in the formula,
Here is one, that also screens out the year:
Example for Person 1, Cat A, Month 2, Year 2009

=SUMPRODUCT((B1:B1000=1)*(C1:C1000="A")*(E1:E1000 =DATE(2009,2,1))*(E1:E1000<=DATE(2009,3,0)))

Rgds. Hansueli