+ Reply to Thread
Results 1 to 9 of 9

Formula shows result as 0

  1. #1
    Registered User
    Join Date
    02-22-2008
    Posts
    5

    Formula shows result as 0

    I have a simple spread sheet where I need to total up a number of cells that in turn have formulas. The small formulas are working fine, but when I total them up, I get a 0 on the spreadsheet, though the correct total shows up in the box while I am working on the formula. I've tried reformating the formula in different ways (taking out the word "sum", taking out the parentheses, using + instead of , between the various cells, etc.) but nothing makes it work. This is a formula I have used many times before, so I know it SHOULD work...but for some reason it isn't working now. Any ideas?
    Here's the formula in question: Each of the cells contains a simple sum formula:
    =SUM(H72,H65,H57,H50,H38,H31,H24,H16,H10)

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    The formula should work fine, but using the SUM function is unnecessary: =H72+H65+H57+H50+H38+H31+H24+H16+H10 is all you need.

    Post a workbook if you're still having problems.

  3. #3
    Registered User
    Join Date
    02-22-2008
    Posts
    5

    Yeah, but that doesn't work either

    See my original post (I've tried every possibly configuration of the formula, but none works). I am unable to post the spreadsheet, it keeps saying "invalid file"...any suggestions on that part?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    The file needs to be zipped and less than 100K.

  5. #5
    Registered User
    Join Date
    02-22-2008
    Posts
    5

    Here it is...

    But of course we have to follow the rules...which means I have to type some meaningless text into this box or it won't let me post.
    Attached Files Attached Files

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Doesn't seem like much of a burden in return for free help.

    You have a circular reference in H14; its formula is =SUM(H12:H16)

  7. #7
    Registered User
    Join Date
    02-22-2008
    Posts
    5

    Didn't mean to complain

    Sorry...I was just feeling silly because I didn't really have any more to say, but had to keep typing. Thank you SO much for your help...this has been driving me crazy for days. I've had about 20 people here look at it, too. We are ALL blind apparently!

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    You should look at the SUBTOTAL function. The advantage of using it is that SUBTOTAL ignores other SUBTOTALS in its sum range, so you can subtotal at will, and then subtotal the whole thing. Then you don't need to be selective about the elements to include in the final.

    Edit: See Help before you use it for the required arguments.

    Edit2: Excel tells you when ther's a circular reference - look at the message at the bottom of the window.

  9. #9
    Registered User
    Join Date
    02-22-2008
    Posts
    5

    Thanks

    For your help!!!

+ 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