G Guest Dec 17, 2004 #1 am working on a simple way to keep track, a running total, of church member contributions to several funds... thanks JPC
am working on a simple way to keep track, a running total, of church member contributions to several funds... thanks JPC
B Bob Phillips Dec 17, 2004 #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)
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)
G Guest Dec 17, 2004 #3 How about? =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) Click to expand...
How about? =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) Click to expand...
G Guest Dec 17, 2004 #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
More information: I have to clear the data each week and need to keep the running totals from being deleated.. thanks so far Jpc
J Jim May Dec 18, 2004 #6 Bob's suggestion needs to be enclosed using the SUM()... like so: =SUM($A$2:A2)
