formula to count the No of people who scored above 50% in excel
 

In excel how do you set a formula to count the No of people who scored above
50% ??

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% ??

formula to count the No of people who scored above 50% in exce
 

I'm trying to do the same thing, but when I use that formula, my answer
should be 3, but it shows as 300%....how do I fix this?

"Niek Otten" wrote:

=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% ??

formula to count the No of people who scored above 50% in exce
 

Change the format to General (or a number)
format|cells|number tab

Ali wrote:

I'm trying to do the same thing, but when I use that formula, my answer
should be 3, but it shows as 300%....how do I fix this?

"Niek Otten" wrote:

=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% ??




--

Dave Peterson

formula to count the No of people who scored above 50% in exce
 

Thanks so much, you just saved me!!!

"Dave Peterson" wrote:

Change the format to General (or a number)
format|cells|number tab

Ali wrote:

I'm trying to do the same thing, but when I use that formula, my answer
should be 3, but it shows as 300%....how do I fix this?

"Niek Otten" wrote:

=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% ??




--

Dave Peterson