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.

"Tip Rabbit Rabbit" <Tip Rabbit [email protected]> wrote in
message news:[email protected]...
> 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
>
>