Download Excel Start File: [ Ссылка ]

Download Excel File: [ Ссылка ]
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.

свернуть