Hi Bob

It will handle rows hidden, as opposed to filtered, if you substitute 103 for 3
=SUMPRODUCT((SUBTOTAL(103,OFFSET($B$1,ROW($B$2:$B$ 20)-ROW($B$1),,1)))*(C2:C20="a"))

This is a feature that is present in Xl2003, and maybe in XL2002(??)

Regards

Roger Govier


Bob Phillips wrote:
Hi Roger,

Problem is that it does handle filtered rows, but not rows hidden by some
other method. I posted a solution that incorporated a UDF for that case a
few days ago, which also handles the filtered data. Might just use that as
my standard.