Thread: Adding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dig Dig is offline
external usenet poster
 
Posts: 17
Default Adding

I have several columns that have totals. I created another area of the
spreadsheet where I wanted to use 2 of the totals from 2 columns.

I used the cells address (= I333) in D21 and (=J333) in E21. The showed the
totals as they should and if anything changes in the respective columns these
cells adjust accordingly.

Now I wanted to add these add these (=D21+E21), I got $0. I have done this a
zillion times but I can't get it to give me a total.

What is going on here?? Why can't I add the two cells that are referencing
the other cells?
Any help appreciated.