| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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% ?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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% ?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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% ?? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of people | Excel Worksheet Functions | |||
| formula to calculate the number of people | Excel Discussion (Misc queries) | |||
| formula to move a scored number to a score sheet | New Users to Excel | |||
| can I have excel count occurrences for 10 people in 7 days | Excel Worksheet Functions | |||
| how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
Linear Mode
