Forum Discussion

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Aug 15, 2022

Re: Counting Rows Based on Multiple Dates

busymamabee 

=COUNTIF($C$8:$C$10,"<"&TODAY())
=SUMPRODUCT(N($C$8:$C$10<TODAY()))

 An alternative could be SUMPRODUCT.

2 Replies

  • busymamabee's avatar
    busymamabee
    Tin Contributor
    Aug 15, 2022
    I must be doing something wrong...when I entered the bottom formula it came back with 14 as the sumproduct...
    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Aug 15, 2022

      busymamabee 

      Can you attach a screenshot of your file that shows the data and the formula? I can't imagine why the formula returns 14 unless it refers to a different range.