Forum Discussion

L1ANE's avatar
L1ANE
Copper Contributor
Feb 28, 2023

Excel Status bar SUM bug?

If I select the column of figures starting at the bottom-most value, the SUM in the status bar is correctly negative.  If I start with the topmost value, the SUM is positive.
Excel
Formulas and Functions
  • Hecatonchire's avatar
    Hecatonchire
    Feb 28, 2023
    Hello

    It'ss the format of the active cell that is used for display in the status bar => Change it for J4
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 28, 2023
Weird. Any chance you might share that Excel file (anonymized of course)?
  • L1ANE's avatar
    L1ANE
    Copper Contributor
    Feb 28, 2023
    yes happy to - I can't find an option to attach a file though?
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Feb 28, 2023
      An annoying "feature" of this site is that not everyone is allowed to upload Excel files. Perhaps you can upload it to OneDrive (or any other cloud file sharing service) and share a link?

Resources