COUNTIF function for a range of numbers

  • Thread starter Thread starter MugsyMoo
  • Start date Start date
M

MugsyMoo

Hi,

I'd love it if anyone can help me out. I want to count how many
instances there are for ranges of values (e.g how many instance are
between 1 and 10, followed by another field for the count of cases
between 10 and 20, etc). I have tried a bunch of stuff with
=COUNTIF(a2:a100, <you can put specific references, but not ranges
here>).

I appreciate any guidance.
Thanks,
MS
 
You can accomplish this by using a combination of "Countif's".

For example, to count instances from 1 *to* 10, *including* 1 and 10 try:

=COUNTIF(A1:A20,"<=10")-COUNTIF(A1:A20,"<1")

To count instances *between* 1 and 10, *excluding* 1 and 10 try:

=COUNTIF(A1:A20,"<10")-COUNTIF(A1:A20,"<=1")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,

I'd love it if anyone can help me out. I want to count how many
instances there are for ranges of values (e.g how many instance are
between 1 and 10, followed by another field for the count of cases
between 10 and 20, etc). I have tried a bunch of stuff with
=COUNTIF(a2:a100, <you can put specific references, but not ranges
here>).

I appreciate any guidance.
Thanks,
MS
 
Back
Top