How to stop running total on excel spreadsheet

R

RC

How do I prevent a running total on spreadsheet. ie, A3+B2 is a total for B3.
Yet B4,B5,B6 shows same total. How do I keep these other cells @ zeros or
blank until next entry? Thanks.
 
B

Bob Phillips

In B3, use

=IF(A3<>"",A3+B2,"")

and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

RagDyer

Just another way, returning zero instead of null.

With first value starting in A2, try this in B2:

=SUM($A$2:A2)*(A2<>"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


In B3, use

=IF(A3<>"",A3+B2,"")

and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top