Good evening all,
I am looking for a formula that will allow me to count up how many times a 'Y' is entered consecutively on my spreadsheet.
The spreadsheet will have dates across the top and names down the side.
I would like the formula to recognise that when a N has been entered it needs to reset and start counting up the Y's again from 0.
Please see the example spreadsheet attached - I would like the formula to calculate the last column for me (I have manually entered the numbers to show you what the final number would be if the calculation was correct).
Any help appreciated.
Thanks
Sara
Bookmarks