Thread: COUNT IF with unconditional AND on cell dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default COUNT IF with unconditional AND on cell dates
sorry,

=SUMPRODUCT(--(Requests!H1:H65535<=&DATE(2012,4,31))*(Requests!D 1:D65535="Marcus Comins"))

--
isabelle


Le 2012-04-13 16:37, isabelle a écrit :
=SUMPRODUCT(--(Requests!H1:H65535,"<="&DATE(2012,4,31))*(Request s!D1:D65535="Marcus Comins"))
Reply With QuoteReply With Quote