Hi Bob

That's cool.
Never thought about using the Subtotal function inside Sumproduct like that.

Regards

Roger Govier


Bob Phillips wrote:
Here is an example where B2:b20 is filtered, and a condition in A2:A20 is
tested

=SUMPRODUCT((SUBTOTAL(3,OFFSET($B$1,ROW($B$2:$B$20 )-ROW($B$1),,1)))*(C2:C20=
"a"))