calculate average in percentage coloumn with #DIV/! (ignore error

1. calculate average in percentage coloumn with #DIV/! (ignore error

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  Register To Reply

2. Re: calculate average in percentage coloumn with #DIV/! (ignore error

On Tue, 6 Sep 2005 02:46:41 -0700, "neelsels SA" <neelsels
SA@discussions.microsoft.com> 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  Register To Reply

3. Re: calculate average in percentage coloumn with #DIV/! (ignore error

Another way (less pedagogic, though):

=AVERAGE(IF(ISNUMBER(A1:A99),A1:A99))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

neelsels SA 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

--

Dave Peterson  Register To Reply