+ Reply to Thread
Results 1 to 3 of 3

Sum not showing

  1. #1
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Solved :Sum not showing

    1-the Sum in the end of the table not calculating ..
    2-an Error when i open the sheet

    any help !!
    i attached the file
    Attached Files Attached Files
    Last edited by nasser; 03-14-2007 at 09:02 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Cell I43 has a circular reference (i.e. the formula in that cell refers to I43, which you normally don't do)

    I presume this is in error. Try copying the formula from I42 into I43 then the error message should disappear and the sum for the column should display

  3. #3
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Thumbs up Solved

    Quote Originally Posted by daddylonglegs
    Cell I43 has a circular reference (i.e. the formula in that cell refers to I43, which you normally don't do)

    I presume this is in error. Try copying the formula from I42 into I43 then the error message should disappear and the sum for the column should display
    thank you for ur fast reply and ur great help

    good luck

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1