View Single Post
  #1   Report Post  
Tip Rabbit Rabbit
 
Posts: n/a
Default Min Formulas in #VALUE! Cells

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