sum formula in excel
 

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

sum formula in excel
 

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


pippawl wrote:
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!!

sum formula in excel
 

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

"pippawl" wrote:

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

sum formula in excel
 

wrote:
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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200609/1

sum formula in excel
 

Florida User wrote:
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!

--
Message posted via http://www.officekb.com