Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows

Channel Avatar
Comment
X
Share
Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows
Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows
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.

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *