J
JPC100
am working on a simple way to keep track, a running total, of church member
contributions to several funds... thanks JPC
contributions to several funds... thanks JPC
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
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)
P
Peo Sjoblom
How about?
=SUM($A$2:A2)
<g>
Peo
=SUM($A$2:A2)
<g>
Peo
Bob Phillips said: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)
J
JPC100
More information: I have to clear the data each week and need to keep the
running totals from being deleated.. thanks so far Jpc
running totals from being deleated.. thanks so far Jpc
F
Frank Kabel
Hi
then not possible with formulas alone
then not possible with formulas alone
J
Jim May
Bob's suggestion needs to be enclosed using the SUM()...
like so:
=SUM($A$2:A2)
like so:
=SUM($A$2:A2)