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
This an array formula, confirmed by pressing CTRL-SHIFT-ENTER:
=MIN(IF('Q3-5'!$G$1:$G$5="Condo",'Q3-5'!$F$1:$F$5,""))
You will need to make sure the ranges are correct.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
{=MIN(IF('Q3-5'!G1:G118="Ranch",'Q3-5'!F1:F118))} solved my problem. Thanks, for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks