+ Reply to Thread
Results 1 to 4 of 4

Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Silverdale, WA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

    WoW Characters.xlsx
    On line 2, the =Sum(B2:L2) is 15+15+15+15+30 and results in 30 being answer when it should be 90. then the next formula =IMSUM(M2,O2) should be 90 -8=82 but actually says 30-8=0. I am having issues finding out where the issue is and this is a multipage program I am working on even retyping it over and over. If anyone is able to help find the issue, it would be much appreciated. Thank you. I attempted to attach the file.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,726

    Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

    There is nothing wrong with your SUM() formula. The problem is that you have a circular error, on sheet2 B2:B3. Remove that range (which is trying to sum a bunch of text anyway??) and the formulas work just fine

    also, on a side note in sheet1 D2, you have this...
    =IF(OR(Declah!B2="0"),"",Declah!B2)

    an OR statement takes at least 2 arguments, but in this case seems unnecessary? Perhaps just...
    =IF(Declah!B2=0,"",Declah!B2)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

    Just correct this one then the issue will get resolved

    In Lansalot sheet

    B2 cell formula should be
    =SUM(C2:AH2)

    Drag it down...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    04-04-2013
    Location
    Silverdale, WA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

    Thanks a lot everyone. Don't know how I missed that.

+ 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