%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