AutoSum Function Error

[quirky]

When I highlight a column of numbers, the sum is not shown at the bottom right hand corner. So, I typed =SUM(D2:D32) on an empty cell. 0 is displayed as the answer. The same thing happens when I use the auto sum key.

Please advise. Thank you.

 

[Calypso]

The only time I've seen this is when the "numbers" you're trying to sum have been entered as Text.

Use =Value() against each of the numbers to sum to return a numeric version.

You should then be able to sum the results.

 

[Aladin Akyurek]

On 2002-08-24 03:00, quirky wrote:
When I highlight a column of numbers, the sum is not shown at the bottom right hand corner. So, I typed =SUM(D2:D32) on an empty cell. 0 is displayed as the answer. The same thing happens when I use the auto sum key.

Please advise. Thank you.

( 1.) Select an empty, unused cell.
( 2.) Activate Edit|Copy.
( 3.) Select D2:D32.
( 4.) Activate Edit|Paste Special >Add.

The above recipe will modify the underlying format of the range D2:D32 from Text to Number. Summing should now give the desired result.

 

[quirky]

thanks!

i think i've figured out the problem. i inadvertently copied numbers off a website and tried to do an auto-sum on them. no wonder it didn't work cos' it was text.