Formula not calculating total

D

Debsy

Hi

I'm doing a report in excel and when I try to use autosum to add up my columns, it doesn't add up the columns requested. Instead, it just types the formula in the cell destination.

Hope someone can help, otherwise I've got to get my calculator out!

Thanks

Debbie
 
P

Paul

Debsy said:
Hi

I'm doing a report in excel and when I try to use autosum to add up my
Click to expand...
columns, it doesn't add up the columns requested. Instead, it just types the
formula in the cell destination.
Hope someone can help, otherwise I've got to get my calculator out!

Thanks

Debbie
Click to expand...

Tools > Options > view tab, under Window options
Check that "Formulas" is NOT checked.

If that's OK, check that the cell(s) you are putting the autosum in are NOT
formatted as text.
 
D

Debsy

Thanks Paul- I've tried all those things and it's still not working. None of the cells are formatted as text, have checked every one

Any more ideas?????
Thanks.
 
P

Paul

Debsy said:
Thanks Paul- I've tried all those things and it's still not working. None
Click to expand...
of the cells are formatted as text, have checked every one!
Any more ideas?????
Thanks
Click to expand...

What happens if you type in a simple formula directly?
Try something such as
=SUM(A1:A5)
where that range has some numbers in it.
 
N

Niek Otten

Hi Debsy,

First format the cell as General, Then enter the formula. Formatting
afterwards has no effect.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Debsy said:
Exactly the same thing happens- it just comes up with the formula in the
Click to expand...
cell.
 
P

Peo Sjoblom

Debsy,

another thing to try that has helped me off and on

first make sure all the cells with formulas are not text, then do
edit>replace, replace what put an equal sign =
in the replace with box also put an equal sign =, so replace an equal sign
with an equal sign. Click OK
Sometimes that will trigger a calculation of the formulas

--

Regards,

Peo Sjoblom


Debsy said:
Exactly the same thing happens- it just comes up with the formula in the
Click to expand...
cell.
 
A

Andy B

Debsy

If you delete your formula, then set you format to General, then retype your
formula, do you get the same result? I'm just wondering if the cell was
formatted to TEXT before you entered the formula, and changing it after the
event is too late.

Andy.

Debsy said:
Exactly the same thing happens- it just comes up with the formula in the
Click to expand...
cell.
 
D

Den Hewitt

It is quite likely that the data in your spreadsheet comes from a
external data source i.e. either you or the person that sent you th
data queried a database.

To find out select a cell within the data and click on the arrow nex
to the Name box on the formula bar, and then click the external dat
range name.

Then Edit, Copy, Edit Paste Special Formulas and all will be fine

Cheers

Den Hewit
 
D

Den Hewitt

It could be that you have inserted a column. When this is done the
inserted column inherits the formatting from the column to its left. If
this column is formatted as text then delete the formulae in the
problem column, select the whole column and Edit Clear Format. The
column should now be formatted as general and everything should be OK.
 
Top