COUNTIF

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I need to set up a formula that will count a value if it meets a particular
criteria within a range.

Count if the number is less than 2
Count if the number is between the range of 3 & 5
Count if the number is between the range of 6 & 8
and so on....

Thanks!
 
1.

=COUNTIF(Range,"<=2")

or

=COUNTIF(Range,"<2")

but since the next start with 3 I assume you want to include 2, else use the
second formula

2.

=COUNTIF(Range,">=3")-COUNTIF(Range,">5")

3.

=COUNTIF(Range,">=6")-COUNTIF(Range,">8")

and so on
 
Back
Top