struggling with this small problem with a spreadsheet and wondered if anyone can nudge me in the right direction.
I have spreadsheet with column a having instances of ¨1¨ indicating an event or count should occur. I wish in a further column to keep a count of the 1´s but when the count reaches 12, I´d like to reset the count to 0 again. I´ve managed to get so far as using an OR inside an IF function which tests the value of the count and will set the value to 0 but I´d like to restart the count again.
Do I need to look towards a COUNTIF function, else where of can I use some logic inside of an IF formula to just go up to 12 and reset.