• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count Dates Greater Than

Dear Gurus,

I am looking for a formula (E2) which can count the number of cells which has a ">=D2" from the range $B$2:$B$273, the same formula then continues into cell E3,E4,E5.... while criteria will be cells D3, D4,D5...

As the list is updated often and then a graph is related to it, I wanted to insert the formula to calculate and graph would update accordingly (have got the graph ready).

Thanks in advance,

Kind regards
Arjun
 

Attachments

  • DATE COUNTS.xlsx
    11 KB · Views: 12
As a Microsoft 365 use I have the option of entering a dynamic array formula in cell E2
= COUNTIFS(date, ">="&months)
The only difference is that one formula returns the entire array.
['date' and 'months' are defined names that return the data columns]
 
To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function.

Regards,
Rick Bale
 
Back
Top