Only do Sum function if not "0", IF"0" then return "0"
 

Trying to build function that would do a count of days since last injury.
I'm having trouble getting it to count correctly. right now values are 1 or
0, 0 if there was an injury.

problem chart What I would like
1 = 1 1 = 1
0 = 1 0 = 0
1 = 2 1 = 1
1 = 3 1 = 2
1 = 4 1 = 3
0 = 4 0 = 0
1 = 5 1 = 1

Hmm...my response from a little while ago seems to have evaporated.
I'll try again:

If B1: Calc then
put this formula in B2 and copy down:
=A2*SUM(B1,A2)

Is that what you're looking for?
--
Regards,
Ron