SUMPRODUCT Using Unary on Filtered Range

[ExcelMonkey]

I have a filtered range which l sum using the SUBTOTAL(9, A1:A100
formula. It allows me to sum the filtered range without bringing i
the data that is not included in the filtered range. I want to do
SUMPRODUCT on this filtered range. Normally I would use the followin
SUMPRODUCT(A1:A100, B1:B100). However this will not work on a filtere
range. How can I do this in one formula without creating a ne
column?

Thank

 

[Frank Kabel]

Hi
try
SUMPRODUCT(A1:A100,
B1:B100,SUTOTAL(3,OFFSET($A$1,ROW($A$1:$A$100)-1,0)))