=SUMPRODUCT(--(E2:E200=MAX(E2:E200)),--(ISNUMBER(MATCH(G2:G200,{"ABC","RST"}
,0))),H2:H200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jack Sons" wrote in message
...
Hi all,

In col E I have dates or text or nothing, in col G is ABC or RST or dates
or
text or nothing. and in col H numbers or something else.

I need the (array?) formula that gives me the number in col H for which in
col G is ABC or RST and in col E is the most recent date.

Thanks in advance for your help and my best wishes for a goor 2006.

Jack Sons
The Netherlands