Hi Charles

Otto said to enter 1 in a blank cell and Paste SpecialMultiply, not
enter 0 and multiply.
Since his suggestion "worked" and Biff's didn't, I can only assume that
you made an error when trying Biff's solution.
Both will work, ADDING 0 or MULTPLYING by 1 will have the same effect of
coercing your text values into numeric, then your SUM(D5:D679) should
give you the correct result.

--
Regards

Roger Govier


"Charles Shapiro" wrote in message
news:At0sg.16729$_c1.16048@fed1read05...
Thanks Biff. I did as you suggested and still the formula reports
0.00. The cells were formatted currency. I changed the cells to
numbers and when I type the
=SUM(D5:D679) it puts a blue box around all those cells. As soon as I
hit ENTER, the box goes away and it says 0.00.. I guess I was wrong
on it being a simple formula? :)

The other reply said almost the same thing, except I was told to
MULTIPLY instead of ADD and it made them all 0.

What am I doing wrong? Was it wrong to just highlight the cells D5 to
D679 and format them as NUMBERS and then shouldn't the formula work?
It still says ZERO.

Thanks.

..Chip..




"Biff" wrote in message
...
Hi!

In cell D680 which is one cell after the end of the data in column
D: I put =sum(D:D)

Don't do it that way. If you do you'll end up with a circular
reference.

Use:

I also tried =sum(D5:D679)

But your problem is probably that the numbers in that range are
really TEXT.

Try this.......

Select any empty cell that has not been preformatted. The default
format is GENERAL.
Goto the menu EditCopy
Now, select the range of numbers D5:D679
Goto the menu EditPaste SpecialAddOK

That *should" convert TEXT numbers to NUMERIC numbers and your
formula should now work.

Biff

"Charles Shapiro" wrote in message
news:h5Zrg.16713$_c1.7203@fed1read05...
Hi All.

I want to add up a column. From what I read I can do it two ways.
In cell D680 which is one cell after the end of the data in column
D: I put =sum(D:D) which is suppose add up the column. I also
tried =sum(D5:D679) , but it says $0.00 Does a formula for currency
need to be written another way? It does show the $$ in the total in
cell D680. I'm confused, this should be simple?

Thanks for any help..

..Chip..