MIN from another worksheet

  • Thread starter Thread starter Shelina
  • Start date Start date
S

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".
 
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.
 
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
 
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
 
I tried both formulas and both times the result was 0. It should have been
$182,500. What do you think is the problem?
 
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
 
Back
Top