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 au
code"),--($c$9:$c$9994))

HT

--
Krishnakuma

-----------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...fo&userid=2013
View this thread: http://www.excelforum.com/showthread.php?threadid=38757