You sure you don't want a formula like:

=IF(COUNT(E11:E14)=0,0,SUMIF(E11:E14,"0")/COUNTIF(E11:E14,"0"))
or even:
=IF(COUNTIF(E11:E14,"0")=0,0,SUMIF(E11:E14,"0")/COUNTIF(E11:E14,"0"))



Todd Nelson wrote:

I am calculating percentages and in one cell the formula works and in the
next it gives me a #value error, the formulas match perfectly just different
cells. Can anyone explain this. This is the formula
=IF(E11:E14="",0,SUMIF(E11:E14,"0")/COUNTIF(E11:E14,"0"))

--

Dave Peterson