Need Help with Resetting a Countif Function

All,

I am stuck on what I thought would be the "easy" part of a project - got through all the VBA/SQL lookup part.

What I need to do if have a countif function setup that looks for a specific text string ("Yes") in one column and only counts based on that - Done

It also needs to reset to an output of "1" for any variable if the value of column A (date in this case) changes. - Hopelessly Stuck

Here is what I have, and is working perfectly except for resetting on a new day:

=IF($K2="Yes",COUNTIF($M$2:$M2,$M2),"Same Run")

Attached is a sample of the data I am looking at. The lines in yellow need column O to reset to 1 since the date in column A has changed.

Attached is a VERY trimmed down sample of the data.

If you can help me out, I can adapt and make the edits to match up with the hidden columns in the original.

Got it.

Needed to do a Countifs with an additional criteria...

=IF($K2="Yes",COUNTIFS($M$2:$M2,$M2,$A$2:$A2,$A2),"Same Run")

I had tried this yesterday and mistakenly set the second count criteria to a static range and it threw up the #Value.

Quote from royUK

Your COUNTIF is looking at F. I think you need COUNTIFS

I did need a countifs, I messed up setting a static range as the second condition when I tried that route yesterday.

The columns in my spreadsheet are different than the one I posted here. I cut out all the extra stuff and macros/SQL connections.