ExcelBanter - formula for % passing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula for % passing (https://www.excelbanter.com/excel-worksheet-functions/156478-formula-%25-passing.html)

RKing

formula for % passing

need formula to count only grades above 70

Thanks.

Peo Sjoblom

formula for % passing

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

--
Regards,

Peo Sjoblom

"RKing" wrote in message
...
need formula to count only grades above 70

Thanks.

Barb Reinhardt

formula for % passing

Let's say your data is in A1:A100

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

HTH,
Barb Reinhardt

"RKing" wrote:

need formula to count only grades above 70

Thanks.

All times are GMT +1. The time now is 03:08 PM.