MIN from another worksheet

[Shelina]

Using Excel 2007, I need to a formula on Sheet 2, using the data on Sheet 1,
that gives me the MIN Sales Price (Sheet 1, column F) when the Style (Sheet
1, column G) equals "Condo".

 

[T. Valko]

Try this array formula** :

=MIN(IF(Sheet1!G2:G10="condo",Sheet1!F2:F10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

 

[Jacob Skaria]

Hi Shelina

Try the below array formula . Enter using Ctrl+Shift+Enter

=MIN(IF((Sheet1!G1:G100="condo"),F1:F100))

'error handled version..incase you have any error cells in the range F1:F100

=MIN(IF((Sheet1!G1:G100="condo")*(ISNUMBER(F1:F100)),F1:F100))


If this post helps click Yes

 

[Jacob Skaria]

Ofcourse with the sheet references....

(array entered)
=MIN(IF((Sheet1!G1:G100="condo"),Sheet1!F1:F100))

'error handled version..incase you have any error cells in the range F1:F100
(array entered)
=MIN(IF((Sheet1!G1:G100="condo")*
(ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100))

If this post helps click Yes

 

[Shelina]

I tried both formulas and both times the result was 0. It should have been
$182,500. What do you think is the problem?

 

[Jacob Skaria]

Try this out in a new worksheet with few dummy entries and see
=MIN(IF((G1:G10="condo"),F1:F10))


If this post helps click Yes