An alternative .. try something like this, normal ENTER, copied down:
=LOOKUP(2,1/(P$2:P$10=P2)*(Q$2:Q$10<"Fixed Price"),X$2:X$10)
Adapt the ranges to suit
--
Max
Singapore
---
"Bony Pony" wrote:
SUMPRODUCT(MAX((A1:A7="north")*(B1:B7="high")*C1:C 7))
from another post by Gary's student.