Videos tagged with Formulas

In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 shows you how.

Continuing yesterday's discussion about minus minus, we'll take a look at using SUMPRODUCT vs the new Excel 2007 SUMIFS to solve the multiple conditional sum problem. Episode 900 shows you how.

Richard is building a formula outside of the pivot table that needs to divide by the grand total of the pivot table. In Episode 869, I show two solutions, one of which is an incredibly geeky use of the other type of VLOOKUP.

If you need to make an exact copy of formulas, you can use the method from episode 866 or this Fill Across Worksheets solution. Episode 867 shows you how.

Markus from Germany sends in this tip. Say that you have to make an exact copy of a range of formulas. It is like you need to do a CUT and PASTE, but also leave the original cells where they were. Normally, a Copy and Paste will rewrite the formulas. Using this trick from Markus, you can achieve the desired result. Episode 866 shows you how.

Dan from Texas asks: is there a way to change the color of cells that are precedents of a particular formula. Use the technique in Episode 862 to quickly complete this task.

Can the VLOOKUP return a value one row below the matched value? Episode 854 shows you how to achieve this result using two other functions.

You love VLOOKUPs, but you hate the #N/A error that results. In our Where is it Wednesday edition of the MrExcel podcast, I will show you two ways to prevent #N/A as the result of your VLOOKUP formulas. One harder method in Excel 2003 and an easier method in Excel 2007. Episode 853 shows you how.

Seiichi from Japan asks how to fill in blank cells in column A with the value above the blank. Episode 847 shows you how.

Interesting question from the Southeastern Accounting Show: I want to sum from cell A5 and sum down a certain number of cells. However, the number of cells is stored in cell C5! Episode 837 will show you the obscure but flexible OFFSET function that can solve this problem.