Results 1 to 7 of 7
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    The statusbar in Excel2010 can simultaneously display Average, Count, and Sum for a highlighted block of cells.

    I have a block of cells that contain formulas which give results to 2 decimal values.
    But when I look in the statusbar, the Sum is shown as a rounded integer value.
    I want to see the Sum to 2 decimals.
    I don't see anywhere how to show what I want.

    Any suggestions?

    zeddy

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The display should match the cell formatting.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Moreover, it should match the cell formatting of the Active Cell within the Selection
    Andrew

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    If it did I wouldn't have posted the question.

    So, just to clarify:
    The block of numbers I am highlighting are displayed to 2 decimal places.
    The statusbar Sum is displaying as rounded to integer whole number i.e. no decimal places.
    I need to check the sum to 2 decimals as per the block of cells I am highlighting.

    The numbers in my selected block of cells are the results of a formula.
    In particular, each cell is 'returning' a value based on an OFFSET formula.

    zeddy

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    OK - I figured it out.

    The block of numbers I was highlighting are in a panel of rows, which 'returns' a set of numbers depending on which option button has been selected.
    The types of numbers being 'returned' can be whole numbers, percentages, decimal averages, each with different display characteristics e.g. some will display 2 decimal places, some will display 1 decimal place, others will show as percentages with decimal places etc.
    I found out that the display of the numbers in the block I highlighted was controlled via conditional formatting rules.
    This is why the statusbar wasn't showing what I expected.

    Tricky little @;**!$$^& but I got it eventually.

    zeddy

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Nothing like a bit of sarcasm to get things moving.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    It wasn't sarcasm honest!
    It was frustration!.
    When something doesn't work when you think it should it can drive you bonkers.

    zeddy

Posting Permissions

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