Max formula for specified criteria

[fearthespear]

I need a formula for the highest sales price of a specified criteria. Sales
price for condos only.
Style=column G (condo,victorian,ranch)
sales price=column F
=max(?)
Can you help?

 

[T. Valko]

Try this array formula** :

=MAX(IF(G1:G10="condo",F1:F10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[fearthespear]

It still comes back with the Max sales price for all sales.

 

[fearthespear]

nevermind i didnt do the ctrl sft enter thanks for your help

 

[T. Valko]

You're welcome. Thanks for the feedback!