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"))