Remember Me?

#1
December 17th 04, 07:49 PM
 JPC100 Posts: n/a
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

#2
December 17th 04, 07:56 PM
 Bob Phillips Posts: n/a

Without seeing the data it is hard, but let's say the amounts are in column

=\$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

#3
December 17th 04, 08:05 PM
 Peo Sjoblom Posts: n/a

=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\$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

#4
December 17th 04, 08:29 PM
 JPC100 Posts: n/a

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:

=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\$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

#5
December 17th 04, 08:35 PM
 Frank Kabel Posts: n/a

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:

=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

#6
December 18th 04, 01:24 PM
 Jim May Posts: n/a

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\$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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TEK Charts and Charting in Excel 1 January 13th 05 01:17 AM David Excel Discussion (Misc queries) 2 December 9th 04 03:14 AM STEVE CAMPBELL Excel Discussion (Misc queries) 1 December 7th 04 05:59 PM [email protected] Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM eddie belfast Excel Discussion (Misc queries) 1 December 2nd 04 03:16 PM

All times are GMT +1. The time now is 09:11 PM.