software

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?

=AVERAGE(IF((NOT(ISERROR(B1:B10))),IF(B1:B10lt;gt;quot;quot;,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)

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

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

=IF(B1,A1/B1,quot;quot;)

then you only need a normal AVERAGE function--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=538585