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 C BEFORE today. So in the example below, the total number of rows would be 2 since only the dates in Row 8 and 9 are before today's date.

 

 

excel
Formulas and Functions

3 Replies

    • 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.