Formula not calculating total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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.
 
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.
 
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.
 
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.
 
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
 
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.
 
Back
Top