On Sep 2, 1:18 pm, arch0072
wrote:
thanks that worked, i have a new issue now. i have other cells doing a sum
of the number in the defined cell below and they are coming up #DIV/O! now...
if there a way to make them appear blank if the sumproduct is 0?

Sounds like you have a division, not a sum. Here's a basic formula
format:

=IF(cell=0,"",SUM)