| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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.
|
|
#2
|
|||
|
|||
|
=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? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=473541 |
|
#3
|
|||
|
|||
|
Thanks swatsp0p... it worked perfectly
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report that display percentage below certain level | Excel Discussion (Misc queries) | |||
| Percentage Calculation | Excel Worksheet Functions | |||
| Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
| percentage of production against quotation | Excel Discussion (Misc queries) | |||
| percentage of sales | Excel Worksheet Functions | |||
Linear Mode
