Thread
:
calculate average in percentage coloumn with #DIV/! (ignore error
View Single Post
#
2
Ron Rosenfeld
Posts: n/a
On Tue, 6 Sep 2005 02:46:41 -0700, "neelsels SA" <neelsels
wrote:
calculate average in percentage coloumn with #DIV/!. When the formula has to
calculate the average of a few figures it must ignore all error if present in
the some cells
=AVERAGE(IF(ISERROR(A1:A10)+ISBLANK(A1:A10),"",A1: A10))
entered as an *array* formula. To enter an *array* formula, hold down
<ctrl<shift while hitting <enter. Excel will place braces {...} around the
formula.
Note that I also instructed AVERAGE to ignore Blanks to show you how your
specifications could be expanded.
--ron
Reply With Quote