Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 28, 2023.
There was a scary post online today... the Excel Status Bar sum was WRONG! But it is not wrong... it is a great trick that will win you bar bets from your Excel guru friends!

The Status Bar sum is CORRECT when you select from bottom to top!
But it is INCORRECT when you select from top to bottom!

Down in the YouTube comments, tell me how I managed to do this.

It required no VBA. You can easily do it yourself and freak out your Excel guru friends!

Don't feel bad... when I first saw it, I could not figure it out either. This relies on one of those odd facts about Excel.
maxresdefault.jpg


Transcript of the video:
I've got a mystery for you. This is a great one.
Check this out. The sum of those numbers is 80.
I'm going to select from the bottom to the top.
And I look down here in the Status Bar and of course it says 80. Of course it does.
But I'm going to do the opposite: I'm going to select from the top down to the bottom.
And all of a sudden the status bar is wrong: negative 80!
The first person down in the YouTube comments who tells me how I managed to pull this off, You get a free PDF from the MrExcel store. It's a great one.
 
Format C2 as text and rest of the cells as 0.00;0.00
Input the rest of the cells as -10
 
footoo that seems pretty close. I get 100 and -100, not 80 and -80. Then if I format C2 as a number, I still get the same result.

But the mystery remains as to why the status bar sum is different depending on whether you select top-down or bottom-up.
 
custom number format in C2

-General;-General

The status bar values are displayed using the number format of the first cell
 
Aha. I never noticed that Excel treats the first cell you click on to drag out a range to be the "active" cell, and also that it uses that cell's format to display the status bar stats.

Too bad I can't ❤️ a post in this thread.
 

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top