Sum Not Working

[Darlene Silberman]

Hello,

I have read some of the other issues and none seem to apply to my problem.  I am simply using the "sum" on the home page, the formula/calc opts/are set to automatic.  When I select the auto sum the proper range appears in the cell (D95)  i.e. "=SUM(D41:D94)" yet when I select enter nothing happens.

I have checked the cell format, tried the old @sum nothing works.  Help!

Darlene

[#2]

might post you sheet with details on what you want. if you want information from one column (up and down) to be summed it would be "=sum(A1:A_)". of course enter the cells numbers you want to be added and not what's within the () but ":" is the symbol for through. instead of (a1,a2,a3,a4) you would use (a1:a4). not sure if that helps any but i always just type the formula as often times the quick buttons don't work the way i intend for them to.

[#3]

Hi Darlene,

It seems that the cells format is set to Text!

So, change it to General to Number and then re-enter the AutoSum again.