+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    neelsels SA
    Guest

    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

  2. #2
    Ron Rosenfeld
    Guest

    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

  3. #3
    Dave Peterson
    Guest

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1