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
Strange behaviour. At first it looked as if it did not repro in Desktop Excel, but does in Excel online. But if I change the selection, making sure the negative cell is active I do get a negative sum.
Not good at all! Please use Help, Feedback, I don't like something to report this bug
  • Hecatonchire's avatar
    Hecatonchire
    Iron Contributor
    Feb 28, 2023

    An exemple :

     

     

     

     

     

Resources