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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    average function in Excel 2002

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

    'Average' Function on 1500 lines

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

    average function

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

    Average Function

    Linda RQ, Nov 6, 2009, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    221
    Linda RQ
    Nov 9, 2009
  7. Roger Govier
    Replies:
    0
    Views:
    967
    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:
    758
    קובי
    Feb 3, 2011
Loading...