=SUM((MAX(IF(B1:B100=K1,C1:C100))=C1:C100)*(B1:B10 0=K1))

again as an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gordo" wrote in message
oups.com...
Apologies,
this is the formula that bring back the date no matter when the sku
appears
=max(C1:C100*if(B1:B100=K1, 1, 0))

C includes the date and B is the SKU.

i now want to bring back the qty and qty counted


rgds
Gordon