Autosum Doesn't Update

M

Michael_New_To_Mac

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Does anyone know how to get Autosum to automatically update if one of the Cell values change? It appears you have to go back to the cell and hit Autosum again?? Or am I just missing something?
 
J

JE McGimpsey

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Does anyone know how to get Autosum to automatically update if one of the
Cell values change? It appears you have to go back to the cell and hit
Autosum again?? Or am I just missing something?

Autosum just inserts a formula in a cell.

If one of the values in a dependent cell changes, and if you have
calculation set to Automatic (Preferences/Calculation), the result in
the SUM() cell will change as well.
 

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

missing autosum 2
Autosum mixed text and numbers returns zero 2
Autosum not highlighted 3
toolbar 2
Decimal point vs comma 1
Sum function 2
Excel .xslx document conversion 3
RGB Colors in Graph 1

Top