countif value falls in a range of possible values

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

Matthew Dyer

I am having trouble tring to come up with a solution to this
problem...

I have a range of percentages from L15 to L21. The values are 100%,
98%, 92%, 80%, 76%, 72% and 67%. What I want to do is start a new
column which will tell me how many of these values fall between
100%-90%, 89%-80%, 79%-70%, etc.... I have tried combining if/countif,
but I'm coming up short. obviously it's easy just to count by hand but
I wanted to develop a formula so i can just swap out the range and re-
apply it easily time and time again. thoughts?
 
I am having trouble tring to come up with a solution to this
problem...

I have a range of percentages from L15 to L21. The values are 100%,
98%, 92%, 80%, 76%, 72% and 67%. What I want to do is start a new
column which will tell me how many of these values fall between
100%-90%, 89%-80%, 79%-70%, etc.... I have tried combining if/countif,
but I'm coming up short. obviously it's easy just to count by hand but
I wanted to develop a formula so i can just swap out the range and re-
apply it easily time and time again. thoughts?
Click to expand...

Have you considered the FREQUENCY function?
 
Back
Top