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