Sum function

T

Tomellexx

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to put together a spreadsheet for a business plan and am having problems with the autsum and autofill functions. Firstly, even though I do a simple autosum, if I change a value in a cell, the sum does not change. Secondly, if I try to autofill across columns, the values of those columns simply mirror the value of the first. In other words it copies it. I am at a loss how to get round it as I have been working w Excel for years and have never had this problem. I have experimented with a new worksheet with v simple values and the problem remains. Any ideas?????
 
C

CyberTaz

Go to Excel> Preferences> Calculation, set the option to 'Automatically'.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Autosum Doesn't Update 1
Auto fill alphabet (ABC...)? 5
SUM doesn't work and other cells show a VALUE! 2
Sumif returning incorrect value 2
Autofill Problems 0
missing autosum 2
Results of SUM and IF statement in FormulaBuilder correct, but not in cell 3
Autosum mixed text and numbers returns zero 2

Top