sum formula in excel

P

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!!
 
B

brett.kaplan

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

Florida User

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

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

Top