Average

Giganews Newsgroups
Subject: Average
Posted by:  sdmccabe
Date: Wed, 3 May 2006

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?

Replies