About Sum

[Crimson King]

I'm trying to sum a copied table form a web site. I can copy and paste the information but when I try to add it always results in zero. Do you have any advice?

[TMS]

I suspect that the information you are seeing is text rather than "numbers". It is often the case that data imported from web pages.

You can try using Paste Special with an arithemetic operation to coerce the "numbers" into true numbers.

Put a numeric 1 in a "spare" cell. Copy that cell. Then select all the cells you have imported. Select Edit, Paste Special and choose the Multiply operation.

If that does not work, post your workbook for more detailed investigation.

Regards