Average
 

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, isnt there a way to control the type of error alert that is displayed
in each cell?

Average
 

=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?

Average
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=538585