On Thu, 08 Sep 2005 00:34:32 +0100, Domenic wrote:

Nice one Harlan! I was going to offer the following...

=SUMPRODUCT(B2:B10,SUBTOTAL(9,OFFSET(C3:C11,ROW(C3 :C11)-ROW(C3),0,ROWS(C3
:C11)-(ROW(C3:C11)-ROW(C3)))))

...confirmed with just ENTER, but I prefer your formula. I'll have to
take a closer look at it so that I can understand it.

I'm doing that, too.
I've saved your formula for study too. Thanks.

Darren