Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

## knoydart

795 posts

Ultimate Geek

Trusted

 Topic # 110657 13-Oct-2012 12:40 Hi,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.ThanksKnoydart.

## tigercorp

611 posts

Ultimate Geek

Subscriber

 Reply # 700617 13-Oct-2012 13:07 Just use the modulo function to return the remainder after dividing by 12. So if your 1's are in column A then: =mod(sum(A:A),12)

## Bee

591 posts

Ultimate Geek

 Reply # 700628 13-Oct-2012 13:12 And this to make the 12 display as 12 and not 0 =IF(MOD(Sum(A:A,12)=0,12,MOD(Sum(A:A,12))

## knoydart

795 posts

Ultimate Geek

Trusted

 Reply # 700634 13-Oct-2012 13:28 Thanks both of you for your swift response and help. Works like a treat. Another EXCEL formula in to abuse

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.