Max formula for specified criteria

F

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAVERAGE, MIN, and MAX from another worksheet 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
Consolidation Table from Different Excel Tabs with Different Format 1
AVERAGEIF 4
Mail Merge Directory Conditional Page Break 0
MIN from another worksheet 5
Optimization for 3+ variables 0
DMAX function for Office 2007 1

Top