Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 17th 04, 07:49 PM
JPC100
 
Posts: n/a
Default 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   Report Post  
Old December 17th 04, 07:56 PM
Bob Phillips
 
Posts: n/a
Default

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



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

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




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

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




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

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





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

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I keep a running total of my bills? TEK Charts and Charting in Excel 1 January 13th 05 01:17 AM
Running Scandisk (through) and Defrag David Excel Discussion (Misc queries) 2 December 9th 04 03:14 AM
MY EXEL/WORD OFFICE 2000 IS RUNNING VERY SLOW AFTER DOWNLOADING U. STEVE CAMPBELL Excel Discussion (Misc queries) 1 December 7th 04 05:59 PM
how do i set up a single cell continual entry in excel to total f. [email protected] Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM
RUNNING TOTALS 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.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017