+ Reply to Thread
Results 1 to 5 of 5

Why I'm getting wrong output in sum formula?

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Why I'm getting wrong output in sum formula?

    Hi friends,

    I want to sum range ‘E5:E12, G5:G12’ on ‘Summary’ sheet. The correct answer is: 61700. I’m getting wrong output total: 7000 in cell G13.

    Any help will be highly appreciated.

    Thanking you,
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Why I'm getting wrong output in sum formula?

    I get 114400 as the combined total :
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Why I'm getting wrong output in sum formula?

    Your issue is with...

    Please Login or Register  to view this content.
    You can replace it with:
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Why I'm getting wrong output in sum formula?

    Hi Stephen,

    Perfect! It works fine.

    Thank you to both of you.

    Have a nice time.

  5. #5
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: Why I'm getting wrong output in sum formula?

    Deleting my post due to the sufficient answer already given.
    Last edited by jme1013; 02-20-2017 at 11:55 PM. Reason: Not needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting wrong output countifs formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2015, 12:25 PM
  2. [SOLVED] Getting wrong output by year formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-19-2015, 07:26 AM
  3. it displaying the wrong output in salary amount
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2014, 12:22 AM
  4. [SOLVED] Wrong output for 'F6' students
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2014, 12:32 PM
  5. Quotation marks in formula giving wrong output
    By pcfreakshow in forum Excel General
    Replies: 1
    Last Post: 10-11-2012, 03:00 PM
  6. Getting false when i should be getting true in (=INT(CELL)=CELL)
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2012, 09:51 AM
  7. Wrong Output after first run
    By vijay2482 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2009, 04:20 AM

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