On Mon, 25 Jun 2007 09:54:05 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

=MAX((A1:A11)*(B1:B11="IP"))

This must be entered as an **ARRAY** formula. After typing in the
formula,
hold down <ctrl<shift while hitting <enter. Excel will place braces
{...}
around the formula.

If I am not mistaken, the following "non-array entered" formula will also
work

=SUMPRODUCT(MAX((A1:A1000)*(B1:B1000="IP")))

Rick

Yes, it should.
--ron