Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows. and this video is uploaded by excelisfun at 2013-07-07T18:04:11-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [1W2Y-29TzGw]
| Name | Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows |
| Video Uploader | Video From excelisfun |
| Upload Date | This Video Uploaded At 08-07-2013 01:04:11 |
| Video Discription | Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT-1010.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to multiply and then add two columns with a Filter or Hidden Rows using SUBTOTAL, OFFSET and the SUMPRODUCT function: 1. OFFSET function inside the SUBTOTAL function to create the filtered column of values (rows hidden) 2. SUMPRODUCT to multiply the two filtered columns 3. OFFSET function with a function argument array operation 4. Array Constant 5. Row function to create an array of values SUMPRODUCT on filtered columns. Multiply Filtered Columns. Multiply Columns With Criteria. Multiply Columns Conditionally. [1W2Y-29TzGw] |
| Category | Education |
| Tags | Excel 2013 | Excel 2003 | Excel 2007 | Excel 2010 | excelisfun | Mike Girvin | Highline Community College | Slaying Excel Dragons | Ctrl Shift Enter Mastering Excel Array Formulas | SUMPRODUCT Filtered Columns | Visible Cells Only | multiply and then add two filter columns | multiply filtered columns | OFFSET function with a function argument array operation | OFFSET | SUBTOTAL | Filtered Columns | Hidden Rows | Multiply Two Columns With Hidden Rows In SUMPRODUCT | Hide Unhide Feature |
