#DIV appears if you use average or for instance divide a value with a blank
value/0 not by using the MIN function, if you are using average
then you can use the same technique (range<"") or if there are no values
at all you can use something like

=IF(COUNTBLANK(A1:A10)=10,"",your formula




--

Regards,

Peo Sjoblom

"rmeister" wrote in
message ...

Thank all of you for your help.

Last Question,
If the criteria does not match the #DIV! appears as the result. How
can I write the formula to return a $0 if no criteria is found?


--
rmeister
------------------------------------------------------------------------
rmeister's Profile:
http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=498681