Hi.

Thanks for the response.

I used the following which works nicely.

=SUM(($A4:A$80="Demand")*(SUBTOTAL(9,OFFSET(F4:F80 ,ROW(F4:F80)-MIN(ROW(F4:F80)),,1))))


--
Shane Moore
------------------------------------------------------------------------
Shane Moore's Profile: http://www.excelforum.com/member.php...o&userid=36421
View this thread: http://www.excelforum.com/showthread...hreadid=561936