Eliminate the zero causing this.
If you can't or don't want to do that, consider what you require to
calculate.
What does an average mean if there are no members? Do you want it to be
blank, zero, 16/33rd or one billion? All are equally correct.
In general:
=IF(Divisor=0,YourAlternative,YourAverageFormula)
Or, even worse,
=IF(ISERROR(YourAverageFormula),YourAlternative,YourAverageFormula))
I don't want to be impolite, but advise you to reconsider the structure of
your calculations. In manual calculations, you probably would never try to
calculate an average where division by zero is involved. So why try to do it
with Excel?
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
