"rmeister" wrote in
message ...

I have a formula that looks like this:
{=MIN(IF(SHEET1!A2:A400=SHEET2!A4,SHEET1!B2:B400)) }

What I would like to do is instead of saying A2:A400 and B2:B400 I
would like to do A:A and B:B. When I do this my results turn to zero
because the cells are blank beyond 400.

Is there a way I can write the formula to ignore the blank cells.

Any Help Would be appreciated!!!

rmeister

I don't think it's anything to do with blank cells; try a blank cell in the
fixed range of the formula above - it works perfectly well. The problem is
(if I remember correctly) that you can't use whole column (or whole row)
references in an array formula. You could use A2:A65535.