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 Continue reading “Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts” →

How to use the AutoSum when you need to sum non-contiguous cells in Excel.

This video was created to answer these search terms:
How To Sum Non-Contiguous Cells In Excel?
How To Sum Specific Cells In Excel Formula
How To Count Sum For A Particular Cell In Excell
How To Count Sum Of Certain Cells In Excel
How To Select Cells In Excel For Sum
How To Sum Certain Cells In Excel
How To Sum Different Cells On Excel
How To Sum Different Columns In Excel
How To Sum Different Rows In Excel
How To Sum Select Cells In Excel
How To Sum Two Cells In Excel

How to create a SUM function in Excel.

This answers these search terms:
Autosum A Column In Excel
Excel Easy Way To Sum
Excel How To Add Sum Of ”
Excel How To Create A Sum Formula
Excel How To Use Autosum
Excell How To Make The Sum
Formula To Add In Excel Sum
Hhow To Use Sum In Excel
How Do I Add Cells In Excel For A Sum
How Do I Create A Sum Formula In Excel
How Do I Do A Sum Formula In Excel
How Do I Do Sums In Excel
How Do I Get A Total Sum In Excel
How Do I Insert The Sum Formula In Excel
How Do I Continue reading “How to Create a SUM in Excel #shorts” →

One of the most common questions is how can I do a VLOOKUP in Excel and sum all of the matches? You can’t do it with VLOOKUP because VLOOKUP only finds the first match. It won’t work with XLOOKUP either, because you can only find the last match. Instead, you can use SUMIF or SUMIFS to get the total of all VLOOKUP matches.

This video answers these search terms:
How To Do A VLOOKUP Sum In Excel
How To Lookup And Sum In Excel
How To Sum A Column Using VLOOKUP In Excel
How To Sum A XLOOKUP In Excel
How To Sum In Excel Using Continue reading “Excel Sum All VLOOKUP Matching Rows #shorts” →

How to make a sum negative in Excel.
You have a sum in Excel but want a minus sign in front.
When you total checks, how do you make the sum negative in Excel?

This video answers these common search queries:
How To +/- A Sum In Excel
How To Do Minus Sum In Excel
How To Do Minus Sums On Excel
How To Make A Sum Negative In Excel
How To Make Sum Negative In Excel
How To Minus A Sum On Excel
How To Put A Total Sum As A – In Excel
How To Put A Total Sum As A negative In Excel
How To Put A Total Sum Continue reading “How to Make a Sum Negative in Excel #shorts” →

Microsoft Excel – How to Unhide ALL rows and columns?
There appear to be a lot of people who want to know how to unhide all columns or all rows in a single command. This short video will show you how.

This video answers these Bing searches:
Excel How Do You Unhide
Excel How To Unhide Cells
Excel How To Unhide Hidden Cells
How Can You Unhide All In Excel
How Do I Unhide All In Excel
How Do I Unhide All On Excel
How Do I Unhide Cells In Excel
How Do I Unhide Cells On Excel
How Do I Unhide In Excel
How Do You Unhide A Cell In Excel
How Continue reading “Excel Unhide All Rows and Columns #shorts” →