Percentage Formula
If your results are in column C and you have say 30 students then
=COUNTIF(C1:C30,"=pass")/30 formatted as percentage will give you pass
percent
--
Gary''s Student
"Kittykat8181" wrote:
I have a table of passes and fails from my students as i am a driving
instructor and i would like to have a running column showing the percentage
of passes/fails
ie
name test date result
joe bloggs 11/05/2005 fail
joy biggs 17/06/2005 pass
would like a fourth column or even just one cell showing the percentage, wot
formula do i need to do this please x
|