How to stop running total on excel spreadsheet

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.

In B3, use

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

and copy across

--

HTH

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


"RC" <[email protected]> wrote in message
news:[email protected]...
> 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.

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!
==============================================


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
In B3, use

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

and copy across

--

HTH

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


"RC" <[email protected]> wrote in message
news:[email protected]...
> 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.