using sum button

[adam h]

I try pasting a bunch of numbers from a website into
excel. Everything comes over fine, but when I try to sum
the column using the sigma button, the result is just zero.

Please help! I have a lot to sum.

Thanks for your help.

 

[Trevor Shuttleworth]

Adam

sounds like the "numbers" are being pasted as text. That would probably be
the case if trailing spaces are included in the copy.

Regards

Trevor

 

[Earl Kiosterud]

Adam,

Trevor's probably right. If that's the case, try this formula:

=SUM(C1:C20+0)

It's an array formula; press Ctrl-Shift-Enter any time you enter it or
change it.