MrExcel Excel Videos

How to Fix the SUM function in Excel. How to tell what is included in the SUM function in Excel. Edit what is being summed. Why is there a green triangle on my SUM function in Excel? Formula Omits Adjacent Cells in Excel. Update Formula to include cells in Excel. Today, you have a SUM in Excel which appears to be too small for the numbers you are adding up. Use the F2 key to figure out what numbers are in the sum. One solution is to drag the range to include many blank cells. But another solution is to convert the range to a Table so the Sum will automatically expand as more numbers are added to the table. This video answers these common search terms: How to get Excel to auto update formulas What are the green triangles on the Excel...

You have a sum in Excel. You want to add some text to the sum. Maybe something like "Please remit $" before the number. This video shows two methods. The first uses Concatenation. The second uses a custom number format, with different text showing for positive, negative, and zero. Also in this video: using F4 to repeat a command. Common Search Terms answered by this video: how to concatenate a number with text in Excel how to add text to sum in Excel. how to join text and a number in Excel. Table of Contents (0:00) Concatenate text with SUM (0:26) Custom number format to add text before number (1:40) Wrap-up

You have a range of numbers in Excel but there are some error cells. When you try to use AutoSum, it selects the wrong range. When you select the correct range, the Sum is replaced by an error. This video shows two methods for solving the problem: With Microsoft 365, add IFERROR inside the SUM. With older Excel, use the AGGREGATE function to ignore errors. This video answers these common search terms: How to get excel to ignore error in sum. How to ignore errors when summing in Excel. How to sum columns in Excel with "#value!". How to sum columns in Excel with # value. How to sum excel ignoring n/a. How to sum in excel excluding. How to sum in excel with #n/a. Table of Contents (0:00) AutoSum with Error cells (0:18) Add IFERROR...

Several people asked about typing a Sigma or the Sum Symbol in Excel. There are several different ways to do this, and none are particularly easy to figure out. Perhaps the best way is =UNICHAR(931) followed by F9. This video answers these search terms: how to do sigma in excel how to find sigma in excel how to find the sum symbol in excel how to get sum symbol in excel how to get the sum symbol in excel how to insert sum symbol in excel how to type sigma in excel how to use sigma in excel what is the sum symbol called in excel

How can you sum data in Excel that has been filtered? You have to apply the filter first and then AutoSum in Excel. This video answers all of these common search terms: can i sum data in excel that is filtered excel how to make sum change with filter excel how to sum a filter excel how to sum cells from a filter excel how to sum filtered column excel how to sum with filter how do i sum filtered data in excel how do you get a sum from excel when filtering how do you sum a filtered column in excel how do you sum only filtered items in excel how do you sum only visible cells in excel how to add sum of filtered numbers excel how to apply sum formula to filtered cells in excel how to autosum when filtered in excel how to calculate sum with...

Why can't Excel correctly sum a simple timesheet in Excel? This video shows method 1: Choose the crazy 37:30:55 number format. Method 2: Convert the times to hours when you subtract start time from end time. This video answers all of these common search terms: excel how to calculate sum of time hot to do a times sum in excel how do find the sum of time in excel how do i sum time in excel ? how do you format a cell in excel to sum time youtube how do you sum time format in excel how do you sum time in excel how do you sum time inexcel how to add sum of time in excel how to add up the sum of times of a column in excel how to do a time sum in excel how to find the sum in excel for time how to get sum of time in excel how to get the sum of...

Some call it a 3D reference or a spearing formula. If your Excel worksheets are all perfectly lined up, you can use this formula to sum across worksheets in Excel. But if your worksheets are not in the same sequence, then you can use TOCOL, SORT, UNIQUE, and SUMIFS to solve the problem. This video answers these search terms: how ot easy sum tabs in excel how sum across multiple sheets in excel how to calculate sum from other tabs in excel how to do sum across two worksheets in excel how to do sum of cells in multiple sheet in excel how to get multi excel sheets to sum how to get sum from multiple sheets in excel how to sum across excel tabs how to sum an entire workbook in excel how to sum cells from different excel sheets how to sum...

One of these four shortcut keys stops working in Windows versions of Excel: Ctrl+9 to hide rows Ctrl+Shift+9 to Unhide rows Ctrl+0 to hide columns Ctrl+Shift+0 to unhide columns If the last one is not working for you, it is because the Windows shortcut to switch language is assigned to Ctrl+Shift. This video shows the Control Panel setting to make Ctrl+Shift+0 or Ctrl+Shift+) start unhiding columns again.

Today's question from Bill. Did you know that Excel's Advanced Filter is returning partial matches? A phrase in the criteria range is treated as Phrase*. This is an annoying problem. Excel Help sort of alludes to this problem and suggests a formula in the criteria range of Advanced Filter. But if you try to automate the creation of those formulas in the criteria range, it does not work. In this video, a convoluted set of steps to automate formula creation with a carat in place of the equals sign, then Replace to change the text into a formula. This allows the Advanced Filter to work. This all begs the question: Why am I trying to use Advanced Filter at all? How about IFERROR(SIGN(MATCH))) and filter that column to 1? Table of...