Forum Discussion
L1ANE
Feb 28, 2023Copper Contributor
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.
- Feb 28, 2023Hello
It'ss the format of the active cell that is used for display in the status bar => Change it for J4
L1ANE
Feb 28, 2023Copper Contributor
yes happy to - I can't find an option to attach a file though?
JKPieterse
Feb 28, 2023Silver Contributor
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?
- L1ANEFeb 28, 2023Copper Contributor
- HecatonchireFeb 28, 2023Iron ContributorHello
It'ss the format of the active cell that is used for display in the status bar => Change it for J4- L1ANEFeb 28, 2023Copper Contributorthank you! I can't imagine why it's formatted that way, or why the format of that cell should affect the status bar, but it does!
- JKPieterseFeb 28, 2023Silver ContributorStrange 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- HecatonchireFeb 28, 2023Iron Contributor
An exemple :