HI Krish,

That works great, thanks very much for your assistance - it's appreciated.

Matt

"Krishnakumar" wrote:


Hi Greeny,

Try,

=SUMPRODUCT(SUBTOTAL(3,OFFSET($b$9:$b$9994,ROW($b$
9:$b$9994)-MIN(ROW($b$9:$b$9994)),,1)), --($b$9:$b$9994="relevant aux
code"),--($c$9:$c$9994))

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=387578