Count if not 0 or return value of 0

M

Mike Punko

Tryign to setup a chart that would give me a running total of data only if =1
but give me a value of 0 if =0. I've been able to setup the running total of
data but when it comes to a 0 it just gives me the pervision number the
conitunes. Here what I mean.

Problem What I would like
Data Calc. Data Calc.
0 0 0 0
1 1 1 1
1 2 1 2
1 3 1 3
0 3 0 0
1 4 1 1
1 5 1 2
 
R

Ron Coderre

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

Does that help?
 
Top