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

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

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)


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

How about?

=SUM($A$2:A2)

<g

Peo

"Bob Phillips" wrote:

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)


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

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

"Peo Sjoblom" wrote:

How about?

=SUM($A$2:A2)

<g

Peo

"Bob Phillips" wrote:

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)


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

Hi
then not possible with formulas alone

--
Regards
Frank Kabel
Frankfurt, Germany

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

"Peo Sjoblom" wrote:

How about?

=SUM($A$2:A2)

<g

Peo

"Bob Phillips" wrote:

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)


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

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



"Bob Phillips" wrote in message
...
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)


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