I am an educator and I would like to develop a spreadsheet that calculates
the percentage of student grades. For example, The students took a test and I
would like to know that 80% of the class did 80% or better on any assessment.

Please assist...

Say the data was like:

SMITH 51
JOHNSON 69
WILLIAMS 55
JONES 75
BROWN 65
DAVIS 83
MILLER 74
WILSON 81
MOORE 66
TAYLOR 83
ANDERSON 89
THOMAS 55
JACKSON 66
WHITE 74
HARRIS 84
MARTIN 79
THOMPSON 55
GARCIA 89
MARTINEZ 62
ROBINSON 67
CLARK 65
RODRIGUEZ 59
LEWIS 92
LEE 90
WALKER 73
HALL 90
ALLEN 95
YOUNG 59
HERNANDEZ 94
KING 89
WRIGHT 92
LOPEZ 94
HILL 72
SCOTT 57
GREEN 92
ADAMS 54
BAKER 73
GONZALEZ 74
NELSON 68
CARTER 83
MITCHELL 77
PEREZ 80
ROBERTS 90
TURNER 63
PHILLIPS 52
CAMPBELL 63
PARKER 63
EVANS 81
EDWARDS 62
COLLINS 93
STEWART 55
SANCHEZ 98
MORRIS 95
ROGERS 75
REED 57
COOK 62
MORGAN 66
BELL 62
MURPHY 83
BAILEY 71
RIVERA 61
COOPER 86
RICHARDSON 53
COX 76
HOWARD 97
WARD 76
TORRES 68
PETERSON 58
GRAY 56
RAMIREZ 72
JAMES 84
WATSON 52
BROOKS 82
KELLY 58
SANDERS 81
PRICE 100
BENNETT 78
WOOD 77
BARNES 98
ROSS 92
HENDERSON 91
COLEMAN 79
JENKINS 75
PERRY 63
POWELL 85
LONG 66
PATTERSON 74
HUGHES 93
FLORES 58
WASHINGTON 71
BUTLER 86
SIMMONS 94
FOSTER 78
GONZALES 69
BRYANT 67
ALEXANDER 66
RUSSELL 71
GRIFFIN 70
DIAZ 79
HAYES 87
MYERS 65
FORD 71
HAMILTON 60
GRAHAM 67
SULLIVAN 83
WALLACE 50
WOODS 74
COLE 87
WEST 81
JORDAN 95
OWENS 70
REYNOLDS 88
FISHER 100
ELLIS 93
HARRISON 100
GIBSON 68
MCDONALD 68
CRUZ 97
MARSHALL 60
ORTIZ 61
GOMEZ 61
MURRAY 71
FREEMAN 89
WELLS 56
WEBB 80
SIMPSON 64
STEVENS 99
TUCKER 67
PORTER 67
HUNTER 68
HICKS 97
CRAWFORD 91
HENRY 91
BOYD 62
MASON 61
MORALES 82
KENNEDY 91

=COUNTIF(B:B,"" & 80)/COUNT(B:B)
formatted as percent displays:
37.96%

--
Gary''s Student - gsnu200908


"Que" wrote:

I am an educator and I would like to develop a spreadsheet that calculates
the percentage of student grades. For example, The students took a test and I
would like to know that 80% of the class did 80% or better on any assessment.

Please assist...