Average

[Guest]

I am totaling a column of percentage values that also include cells (from a
linked sheet) that display the error alert #DIV/0! in the cells that have no
appropriate value from the linked sheet. How can I total the column (I want
the average percentage) and ignore the alert and display the correct average.
Also, isn’t there a way to control the type of error alert that is displayed
in each cell?

 

[Bob Phillips]

=AVERAGE(IF((NOT(ISERROR(B1:B10))),IF(B1:B10<>"",B1:B10)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[daddylonglegs]

Perhaps you could suppress the errors, if you have a formula like =A1/B1
then you could change to

=IF(B1,A1/B1,"")

then you only need a normal AVERAGE function