Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sum different after sorting (2003)

    I just noticed when I sort a sheet, the total for the column with currency in it changes. If I sum the sheet right after generation, it is one figure. After sorting by date and name, the column with figures in it is a different total. The sheet has several thousand rows in it. I didn't want to go line by line to see where the discrepancy is. Any suggestions?

    Thanks.
    Sam

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: sum different after sorting (2003)

    I would think that the formula with the sum does not reference all the rows in your range, so when you sort it, different cells are not in the total.

    Look at the formula with the sum and ensure it uses all the rows...

    Steve

  3. #3
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum different after sorting (2003)

    Thanks, I'll try that.

    Sam

Posting Permissions

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