View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles Shapiro Charles Shapiro is offline
external usenet poster
 
Posts: 3
Default simple formula not working

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