#1
|
|||
|
|||
COUNTIF [criteria] + give %
Hi guys,
Was trying to crack this one up, got nothing but a head buzzing by now... A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 y y y y n y n n o o What would be a formula to calculate % for: Count ONLY if A2:L2 is 'y' AND 'n', ignoring anything else (blank or 'o') Then give me a % for how many correct answers ('y') vs incorrect answers ('n') So in this example it would be: Total Count: 8 (5 x 'y' & 3 x 'n') % Correct: 63% Any suggestions? Thank you! |
#2
|
|||
|
|||
Code:
=countif(A2:L2,"y")/(countif(A2:L2,"n")+(countif(A2:L2,"y")) |
#3
|
|||
|
|||
Thank you!!
|
Tags |
countif, percentage |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
If IF/AND Criteria is Blank, Give me "Blank" | tbesh | Excel | 1 | 09-07-2015 09:43 AM |
Matching Criteria against a range when criteria is not in contiguous cells?? | GMorris | Excel | 9 | 08-20-2014 02:15 AM |
Save As give Read Only | Royce in ATL | Excel | 0 | 08-19-2012 05:34 PM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |