+ Reply to Thread
Results 1 to 5 of 5

Two differents sums

  1. #1
    Forum Contributor
    Join Date
    04-16-2016
    Location
    bognor
    MS-Off Ver
    10
    Posts
    132

    Two differents sums

    Hi all,

    I have a series of numbers in a Column.Most of the cells empty the actual numbers being intermittent.So to check the sum of these numbers I looked down to the Excel default sum,that is housed on the bottom bar in excel(on the right hand side).Something didn't ring true about the sum amount,so I did an =SUM and got a different figure.

    I then checked it manually and found out that the +SUM function had produced the correct figure,and the default figure was wrong(by almost double).
    Is there a reason for this,could it be because I have blank cells as well as numbers in the column.Another point that might be of significence is that the number in the said columns was arrived at by using a formula .I cant see how that would effect it but I am new to a lot of Excel.Am I making a common mistake.Any suggestions most welcome.

    Kind Regards
    John

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,878

    Re: Two differents sums

    I think to make any diagnosis on this one that we'd need to see some sample data.
    Would it be possible to post a sample workbook, desensitized if necessary.

    BSB

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

    Re: Two differents sums

    Agree we would need to see a sample workbook of this, but do you by chance have subtotals in that range?
    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

  4. #4
    Forum Contributor
    Join Date
    04-16-2016
    Location
    bognor
    MS-Off Ver
    10
    Posts
    132

    Re: Two differents sums

    Hello both,
    Thankyou both for your replies,I managed to solve the problem.I found another series of numbers way down the column!!! I dont know how I managed that but they were adding to the sum.So it's a red face from me .Many thanks again for your replies.
    Kind regards
    John

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

    Re: Two differents sums

    Im happy you got this resolved

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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] Formula to return the lowest value in differents tables
    By Keldion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2016, 06:40 PM
  2. [SOLVED] Sum differents worksheets
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-02-2016, 11:53 AM
  3. [SOLVED] Differents dates in differents sheets
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2016, 12:57 PM
  4. [SOLVED] Copy and Paste differents ranges
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-21-2015, 12:10 PM
  5. Check cell and sum differents worksheets
    By Salivan in forum Excel General
    Replies: 4
    Last Post: 05-13-2014, 12:13 PM
  6. Excel file with differents format of date
    By KateBackOffice in forum Excel General
    Replies: 1
    Last Post: 11-13-2013, 02:04 PM
  7. Join differents words in cells seperated by ;
    By corvito in forum Excel General
    Replies: 8
    Last Post: 04-08-2007, 11:02 PM

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