formula for % passing

[RKing]

need formula to count only grades above 70

Thanks.

 

[Peo Sjoblom]

=COUNTIF(A:A,">70%")

 

[Barb Reinhardt]

Let's say your data is in A1:A100

=COUNTIF(A1:A100,">70%")

HTH,
Barb Reinhardt