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

G

Guest

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a Sum and an Array 15
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
SUMIF to sum multiple columns of data? 2
Excel VBA 1
Counting occurance of >0 in two columns 3
Finding dynamic maxima 8
Sumproduct Search, Sum Durations 5
Count rows where a specific value appears in any of 4 columns 5

Top