| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number 75% and < 90%
I am trying to calculate the number of people that have achieved a % rating
between 75% and 90%. All of the data is in one column. I have tried countif, this only allows one set of criteria : =COUNTIF(R:R,"90%"), I cannot get any results with DCOUNT either. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count number 75% and < 90%
Sassy,
Try =COUNTIF(A:A,"<90%")-(COUNTIF(A:A,"<75%")) Format as general Mike "Sassy" wrote: I am trying to calculate the number of people that have achieved a % rating between 75% and 90%. All of the data is in one column. I have tried countif, this only allows one set of criteria : =COUNTIF(R:R,"90%"), I cannot get any results with DCOUNT either. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count number 75% and < 90%
Hi Mike,
This works great, thanks Honey Bunny. This left me sleepless last night. S "Mike H" wrote: Sassy, Try =COUNTIF(A:A,"<90%")-(COUNTIF(A:A,"<75%")) Format as general Mike "Sassy" wrote: I am trying to calculate the number of people that have achieved a % rating between 75% and 90%. All of the data is in one column. I have tried countif, this only allows one set of criteria : =COUNTIF(R:R,"90%"), I cannot get any results with DCOUNT either. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count number 75% and < 90%
Then take a nap now. Thanks for the feedback.
"Sassy" wrote: Hi Mike, This works great, thanks Honey Bunny. This left me sleepless last night. S "Mike H" wrote: Sassy, Try =COUNTIF(A:A,"<90%")-(COUNTIF(A:A,"<75%")) Format as general Mike "Sassy" wrote: I am trying to calculate the number of people that have achieved a % rating between 75% and 90%. All of the data is in one column. I have tried countif, this only allows one set of criteria : =COUNTIF(R:R,"90%"), I cannot get any results with DCOUNT either. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Linear Mode
