MIN from 1 col. based on data in another col.

I need to a formula that gives me the minimum value of column F(1-118) of sheet Q3-5, among the entries where in the value of column G(1-118) = Condo. The formula will be entered on worksheet Q6-7.

Example: The formula should look at all the Condos and return the minimum value among all Condos. In this example, the result would be $129,000.

Sheet is Q3-5, Table is SalesData3

F G
Sales Price Style
$129,000 Condo
$74,000 Victorian
$158,500 Ranch
$215,000 Condo

You can use this formula

=MIN(IF('Q3-5'!G1:G118="Condo,'Q3-5'!F1:F118))

This is an "array formula" which needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

{=MIN(IF('Q3-5'!G1:G118="Ranch",'Q3-5'!F1:F118))} solved my problem. Thanks, for your help!