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:
    396
    Domenic
    May 8, 2005
  2. Logan

    'Average' Function on 1500 lines

    Logan, May 25, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    219
    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:
    246
  4. inoexcel

    average function

    inoexcel, Apr 18, 2006, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    213
    Guest
    Apr 18, 2006
  5. pjr
    Replies:
    13
    Views:
    427
    Ron Coderre
    Mar 27, 2008
  6. Linda RQ

    Average Function

    Linda RQ, Nov 6, 2009, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    165
    Linda RQ
    Nov 9, 2009
  7. Roger Govier
    Replies:
    0
    Views:
    886
    Roger Govier
    Jan 16, 2011
  8. קובי

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

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