Forum Discussion

busymamabee's avatar
busymamabee
Copper Contributor
Aug 15, 2022

Counting Rows Based on Multiple Dates

Is there a way to count the number of rows that adhere to a certain date?  The goal would be for the pink cell to count the total number of rows in Column D that are associated with a date in Column...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Aug 15, 2022

busymamabee 

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

 An alternative could be SUMPRODUCT.

busymamabee's avatar
busymamabee
Copper 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.