I have a fomula that is trying to average the totals of individual sections
of averages. I have one section where there is not an average to add to the
formula. I would like to write a formula that would average all of the totals
even if there is a null value so I don't have to rewrite the formula if when
the section gains a value. Currently the null value is represented by
#DIV/0!. Here is what I have so far;
=AVERAGE(I10,I16,I22,I28,I34,I40,I46,I52,I58)
This is what I have tried
-- =AVERAGEIF(I10,I16,I22,I28,I34,I40,I46,I52,I58,"< #DIV/0!")


Please help
Drock-13