Thread: Counting dates greater than a certain time period
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis
 
Posts: n/a
Default Counting dates greater than a certain time period
Forgive me for making this the most convuluted post in the world, but I
have to correct a typo:

=SUMPRODUCT(--(A1:A5403="Active"),--(B1:B5403<DATE(9999,1,1))) =747


should read:

=SUMPRODUCT(--(A1:A5403="Active"),--(B1:B5403DATE(9999,1,1))) =747


Sorry for the confusion:)

Reply With QuoteReply With Quote