+ Reply to Thread
Results 1 to 2 of 2

Percentage of "yes" or "no"

  1. #1
    kpgilber
    Guest

    Percentage of "yes" or "no"


    I am setting up a database that will show me how many wrong entries have
    been made onto our server. Each row will have info regarding the entry
    and the last cell will be say yes or no (yes for right, no for wrong).
    I was wondering if there was an equation i could enter at the bottom of
    the column that would give me a percentage of the yes's or the no's.


    --
    kpgilber

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    =COUNTIF(A1:A1000,"=yes")/COUNTA(A1:A1000)

    --OR--

    =COUNTIF(A1:A1000,"=no")/COUNTA(A1:A1000)

    Format this cell as percent (%)

    this will not count rows with blanks (COUNTA) only counts cells with entries.

    Does this work for you?
    Bruce
    The older I get, the better I used to be.
    USA

+ 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