Its probably because you are entering a "" in the if statement. Try
entering 0 instead. Another way would be to evaluate your array formula
with an IF statement and checking its result if it errors out. If yes,
enter "", else the actual formula.

Infact you could use the same if in your array formula, something
like:

=IF(C5+D5+E5+F5+G5+H5+I5<=0,"",your_array_formula)


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378044