Min Formulas in #VALUE! Cells

[Tip Rabbit Rabbit]

I need a min formula that will give me the minimal value of the cells q1:q76.
Cells q1:q12 have vlaues in them, but q13:q76 do not have values because the
information has not been entered, thus leaving the cells #VALUE!. This
leaves my =MIN(Q1:Q76) at #VALUE!

Please offer any help.

Jenn

 

[Dave R.]

If Q13:Q76 are empty, or contain text, they should be looked over by the min
function ,but you can try

=MIN(IF(ISNUMBER(Q1:Q76),Q1:Q76))
entered with control shift enter to see if that does what you want.