Thread: formula for % passing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default 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.
Reply With QuoteReply With Quote