How do you keep a runnung total?

  • Thread starter Thread starter Pastor Andrew Alexander
  • Start date Start date
P

Pastor Andrew Alexander

In a table called "Member Income" it updates the master income record on
another table called " "Church Income" the formula in have in the Chitch
Income is =SUM('Member Finanical Record'!B9:D9). It updates the record ok,
but each time I input a new number , it does not add to the total but
replaces the runnung total weith the new number.

Ex. Mem Income Church Income total
100 100 100
new entry 120 120 120 the total
should be 220

Andrew
 
Hi Don,
The use of SUM going all the back to the first entry for each
iteration of a subtotal will work, but it is very inefficient.

The original poster did not give a clear example of
what is being totalled.

One of the points on my slowresp.htm webpage is...

Use of SUM Worksheet Function for running balances as in
=SUM(D$2:D2) filled-down can take excessive time (misc 2003-01-31).
http://google.com/groups?as_umsgid=ugDxrXayCHA.2592@TK2MSFTNGP10

If you look at the above example you see a pretty good reason why
I would avoid that.

Use of SUM is fine for simple totals as in
=SUM(D$2:OFFSET(D20001,-1,0)), but not for running balances.
The use of OFFSET
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#offset
in running balances as in =OFFSET(D3,-1,0)+D3 is much better than
=D2+D3 when it comes to maintaining formulas and the timing
difference is insignificant relative to maintenance.
 
Back
Top