Count all values after a certain value

[h12]

Hi all

I have a table like the below and essentially every month the number of 'dates' can change from 0 to 10 back to 5 etc. I essentially want to be able to count the number of dates that appear after 'Date Breach Occurred'. Dates will always follow this title, so hopefully theres a way we can do the count using this. The answer below would be 2 as there are 2 dates after 'Date Breach Occurred'.

Column Title =  Names

Cash Management

Cash Postings

Date Breach Occurred

2023-04-21

2023-09-12

[ed_hayter · Accepted solution]

Lots of ways to approach this.

I opted for a multi row looking for the date breach occurred row as the row above and assigning 1 to the row below that and then for every other row copy the row above. So any row under date breached is 1 - a summarize then sums all the 1s

[h12]

Thank you so much for this! My formula was wrong, i didnt use row -1 and used the current row instead so kept getting a '1' with Date Breach Occured row as well. Thank you!