Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Sarah_Lecturer Excel Discussion (Misc queries) 2 April 17th 08 01:46 PM
Adding Mike H Excel Discussion (Misc queries) 0 April 17th 08 12:36 PM
adding ref # John K Excel Worksheet Functions 2 March 7th 07 06:06 PM
Adding Up! ExcelBob Excel Discussion (Misc queries) 2 June 14th 06 02:31 PM
Need help adding : Mark Excel Worksheet Functions 2 August 18th 05 03:59 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"