Category: Business

How to Do Running Total Sum in Excel #shorts

Posted on by Annie D

Two ways to calculate a running total in Excel.
The first method is the sum of the cell in this row and the running total from above.
The second method is an expanding dynamic range.

This video answers these common search terms:
Calculate Cummulative Sum In Excel
Excel How To Do A Cumulative Sum
How To Add Cumulative Sum In Excel
How To Calculate A Cumulative Sum In Excel
How To Calculate A Running Sum In Excel Table
How To Caluclate A Cumulative Sum In Excel
How To Create A Cumulative Sum In Excel
How To Create A Running Sum On Excel
How To Create Excel Running Sum
How To Cumulative Sum Continue reading “How to Do Running Total Sum in Excel #shorts” →

Excel How to Sum Non Contiguous Cells #shorts

Posted on by Annie D

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

#Excel Why IMAGE Function Changes To CONNECT Error #shorts

Posted on by Annie D

Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error!
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic Continue reading “#Excel Why IMAGE Function Changes To CONNECT Error #shorts” →

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

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

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