Min()

[Guest]

hi,

I have the following as a cell formula:

=MIN(P565000)

I would like to add a condition to this Min() to make sure it only retrieves
the Min() where the value in column I is not null.

HOW?

Thanks in advance,
geebee

 

[Bob Phillips]

M IN ignores empty cells already.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Die_Another_Day]

=MIN(IF(I5:I65000="","",P565000)
Then press Ctrl+Shift+Enter as this is an array formula

Charles Chickering