I am using the following formula:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=SUMIF(low!$S$6:$S$87,"<0")/J17
It works OK when there is data in cell J7
If there is no data it gives a #DIV/0! Error
<o> </o>
I want to incorporate the following:
<o> </o>
=IF(COUNT(J17)=1,((SUMIF low!$S$6:$S$87,"<0")/J17),” ”
It doesn’t work
What is missing or is there a better way?
<o> </o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=SUMIF(low!$S$6:$S$87,"<0")/J17
It works OK when there is data in cell J7
If there is no data it gives a #DIV/0! Error
<o> </o>
I want to incorporate the following:
<o> </o>
=IF(COUNT(J17)=1,((SUMIF low!$S$6:$S$87,"<0")/J17),” ”
It doesn’t work
What is missing or is there a better way?
<o> </o>