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