Sum + Incentive

[saladha]

I need help with a simple function in excel....I'm a newbie at this program so sorry for the weak question! I'm trying to take the sum of a range but add 1 for every 'x' intervals. What I mean is if I'm trying to tally hours, I want to give an incentive for ever 30 hours reached. Therefore If the sum of a range equals 30, I want the output to be 31. If it's 60 I want the output to be 62, etc.

Thanks in advance!

 

[Jonmo1]

Welcome to the board.

Try

=SUM(A1:A10)+INT(SUM(A1:A10)/30)