=AVERAGE(IF((NOT(ISERROR(B1:B10))),IF(B1:B10<"",B 1: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)

"sdmccabe" wrote in message
...
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?