Re: Average function for letters

Discussion in 'Microsoft Excel New Users' started by joeu2004, Mar 8, 2012.

  1. joeu2004

    joeu2004 Guest

    "ZWarren" <> wrote:
    > I am trying to compute the percentage of the whole
    > A4:A24 range where the "X"s will count as a yes
    > and the blank field will count as a no, adding up
    > all the X's (yes's) and counting them against the
    > blank fields (no's) to get an percentage of how
    > many X's there are compared to blanks


    AVERAGE is the wrong function to use for this purpose. Try:

    =COUNTIF(A4:A24,"X")/ROWS(A4:A24)

    formatted as Percentage.

    Of course, you could replace ROWS(A4:A24) with 21.
     
    joeu2004, Mar 8, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    average function in Excel 2002

    Guest, May 7, 2005, in forum: Microsoft Excel New Users
    Replies:
    13
    Views:
    340
    Domenic
    May 8, 2005
  2. Logan

    'Average' Function on 1500 lines

    Logan, May 25, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    160
    gls858
    May 25, 2005
  3. Guest

    Average Function with Day of Week Criteria

    Guest, Nov 2, 2005, in forum: Microsoft Excel New Users
    Replies:
    8
    Views:
    205
  4. Roger Govier
    Replies:
    0
    Views:
    798
    Roger Govier
    Jan 16, 2011
  5. קובי

    Re: A useful AVERAGE calculation without using the built-in AVERAGE function

    קובי, Feb 3, 2011, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    550
    קובי
    Feb 3, 2011
Loading...

Share This Page