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

I have 2 columns for values of Pass, Fail, NA.
Let's say I have 8 condition to test (actually way more).
The results a 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

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

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!

--------------------
(Ms-Exl-Learner)
--------------------


"Dave" wrote:

I have 2 columns for values of Pass, Fail, NA.
Let's say I have 8 condition to test (actually way more).
The results a 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

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

%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.
--
David Biddulph

"Dave" wrote in message
...
I have 2 columns for values of Pass, Fail, NA.
Let's say I have 8 condition to test (actually way more).
The results a 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