• 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

ARJUNDSOUZA

New Member
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

Peter Bartholomew

Well-Known Member
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]
 
Top