Category: Power Query

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

Posted on by Annie D

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 Create a SUM in Excel #shorts

Posted on by Annie D

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” →

How to Get the Sum At the Top of Excel #shorts

Posted on by Annie D

How to get the sum at the top of Excel?
This short video shows two methods:
Add the sum at the bottom and then Cut using Ctrl+X and paste at the top.
Or, start at the top, click AutoSum, and then select the range of numbers with the mouse.

How To Get Sum At Top Of Excel
How To Sum At The Top In Excel

Excel Sum All VLOOKUP Matching Rows #shorts

Posted on by Annie D

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 #shorts

Posted on by Annie D

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” →

Excel What is the Shortcut for AutoSum

Posted on by Annie D

Many people are asking about the AutoSum shortcut in Excel.
How To Auto Sum In Excel Shortcut
How To Autosum In Excel Shortcut
How To Do A Sum Shortcuton Excel
How To Shortcut Insert A Sum Formula In Excel
How To Sum A Column In Excel Shortcut
How To Sum In Excel Shortcut
What Are The Shortcut Keys For Autosum Excel
What Is The Keyboard Shortcut In Excell For Sum Function

Excel Unhide All Rows and Columns #shorts

Posted on by Annie D

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” →

Excel Why Is SUM Not Appearing in the Status Bar at Bottom #shorts

Posted on by Annie D

Why is Excel not showing the SUM in the status bar at the bottom of Excel?
There are a few reasons covered in this short video.
1) You only selected a single cell
2) You’ve selected a range of text numbers
3) One or more error cells in the selection
4) Someone turned off the SUM

#Excel How to SUM Only The Positive Numbers in Excel #shorts

Posted on by Annie D

How to sum only the positive numbers in Excel?
This video shows how to use SUMIF or SUMIFS.

This video matches these search terms:
how to calculate sum of only the positive numbers in excel
how to do a sum of only positive values in excel
how to sum negative and positive total numbers in excel
how to sum positive and negative in excel

Excel How To Unhide Specific Column In Excel #shorts

Posted on by Annie D

How to unhide one specific column in Excel.
Say that C, F, and E are hidden columns in Excel.
You only want to unhide column D but leave C & E hidden.
This video shows you how.

Common searches:
How to selectively unhide cells in Excel.
How to selectively unhide columns in Excel.
How to unhide a specific column in Excel.
How to unhide certain columns in Excel.
In Excell how to unhide a single column.