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