how do i keep a running total for contributions to several funds

[Guest]

am working on a simple way to keep track, a running total, of church member
contributions to several funds... thanks JPC

 

[Bob Phillips]

Without seeing the data it is hard, but let's say the amounts are in column
A. In B2, add

=$A$2:A2

and then copy down by each amount

--

HTH

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

 

[Guest]

How about?

=SUM($A$2:A2)

<g>

Peo

Without seeing the data it is hard, but let's say the amounts are in column
A. In B2, add

=$A$2:A2

and then copy down by each amount

--

HTH

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

 

[Guest]

More information: I have to clear the data each week and need to keep the
running totals from being deleated.. thanks so far Jpc

 

[Frank Kabel]

Hi
then not possible with formulas alone

 

[Jim May]

Bob's suggestion needs to be enclosed using the SUM()...
like so:
=SUM($A$2:A2)