using sum button

A

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.
 
T

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
 
E

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.
 
Top