Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I keep a running total of my bills? | Charts and Charting in Excel | |||
Running Scandisk (through) and Defrag | Excel Discussion (Misc queries) | |||
MY EXEL/WORD OFFICE 2000 IS RUNNING VERY SLOW AFTER DOWNLOADING U. | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
RUNNING TOTALS | Excel Discussion (Misc queries) |