sum formula in excel

[pippawl]

I have never used formulas in excel before and am battling a bit.

I am trying to add just one simple column of numbers but am having no luck.

I double click on the cell where I want the total to be and then click on
auto sum, then 'highlight' the cells I want to be added up and then press
enter.

The answer I receive is =SUM(H4:H31) which is the correct span of cells.

Why is it not giving me the total in numbers?

Please help I am going crazy!!

 

[brett.kaplan]

You might be in the show formula mode - press CTRL + ~ and see if that
helps...

 

[Florida User]

Go To Tools > Options > Tab > Formulas
and make sure that it is NOT checked

 

[pippawl via OfficeKB.com]

You might be in the show formula mode - press CTRL + ~ and see if that
helps...

I have never used formulas in excel before and am battling a bit.

[quoted text clipped - 9 lines]

Please help I am going crazy!!

Problem sorted thanks for the help!

 

[pippawl via OfficeKB.com]

Go To Tools > Options > Tab > Formulas
and make sure that it is NOT checked

I have never used formulas in excel before and am battling a bit.

[quoted text clipped - 9 lines]

Please help I am going crazy!!

It's doing what it should now thanks!