Thread: formula to count the No of people who scored above 50% in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default formula to count the No of people who scored above 50% in excel
=COUNTIF(A1:A5,"50%")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Abs" wrote in message ...
| In excel how do you set a formula to count the No of people who scored above
| 50% ??


Reply With QuoteReply With Quote