Microsoft Excel 2007

Hello,

I want to add all values in a C column in Excel. I try this function: =SUM(C2:C248)

The result is however 0. What is wrong with the function?

I appreciate any help!

One of your numbers is probably entered as TEXT All numbers in Excel are right justified, so if any of your numbers are left justified then it is probably text.

MIKE

So perhaps all the numbers have been copy/pasted and are entered as text. Here is a quick and easy way to insure all your numbers are numbers:

In any blank cell, type the value 1

Select the cell in which you typed 1

then click Copy on the Edit menu.

Select cells C2 through C248

On the Edit menu, click Paste Special

Under Operation, click Multiply

Under Paste, click Values

and then click OKMIKE

Could be the numbershave a trailing space.

That will mess with =SUM also, see this post:

http://www.computing.net/answers/of...But, until we hear more from the OP where just guessing.

MIKE

Ask Your Question

Weekly Poll

Do you think third-party cookies should be blocked by browsers?

Discuss in The Lounge

Poll History