HOW DO I GET COLUMN TOTALS TO AUTO UPDATE?

G

Guest

I have set up ledger sheets in Excel for our clients, recording balance
forwards from the manual system, then put in a formula to add payments and
subtract disbursements. When I set up the formula, (i.e- SUM(b9-c10+d10),
the first line worked fine, then when I used the handle to drag the formula
down the total column for subsequent entries, the totals do not update
themselves when I put in new entries. I have tried going back and
re-entering the formula, but keep getting the same result. HELP!
 
P

Peo Sjoblom

1.

You don't need the SUM


=B9-C10+D10


will suffice


2. do tools>options>calculation and make sure it is set to automatic, right
now you have manual
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving totals of rows in sort mode 1
Newbie Formula Question - how to get formula to repeat in each subsequent row? 2
what is the correct formula to add a column with =sum 3
using the =page! feature to transpose a row to column 0
How do I keep the divisor constant in calculating percentage remai 3
Excel Excel: How do I put a formula in a drop down list 11
How do i set up a budget with self totalling column 2
How do I subtract 20% from one column in Excel and place totals i. 2

Top