How do I set up the percentage correctly in this spreadsheet?

D

Dave

I have 2 columns for values of Pass, Fail, NA.
Let's say I have 8 condition to test (actually way more).
The results are: 4 passed, 2 failed and 2 NA's.
I have 3 cells that I want to put the results as a percentage (%Passed,
%Failed, %na). What would be the best way to do this.
Thanks ahead to all that helps.
C1 D1 E1 F1
test results: %Passed %Failed %NA
50 25 25
A3 B3 C3
pass fail
test 1 f
test 2 p
test 3 p
test 4 p
test 5 f
test 6 na
test 7 p
test 8 na
 
M

Ms-Exl-Learner

Paste the below formula in the respective cell which is mentioned below to
derive the result.

D2 Cell
=COUNTIF($B$4:$B$11,"P")/COUNTA($A$4:$A$11)*100

E2 Cell
=COUNTIF($C$4:$C$11,"F")/COUNTA($A$4:$A$11)*100

F2 Cell
=COUNTIF($B$4:$C$11,"NA")/COUNTA($A$4:$A$11)*100

Remember to Click Yes, if this post helps!
 
D

David Biddulph

%Passed =COUNTIF(B4:B11,"p")/COUNTA(A4:A11)
%Failed =COUNTIF(C4:C11,"f")/COUNTA(A4:A11)
%NA =(COUNTIF(B4:B11,"na")+COUNTIF(C4:C11,"na"))/COUNTA(A4:A11)
Format the result cells as percentage, and adjust the ranges as appropriate.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top