Countif between two values

[Ronbo]

How do I get Countif to count the number of occurrences between 95 and 100?

Thanks

 

[Dave R.]

If you want to use countif for this, you'll have to use something like;

=COUNTIF(A1:A10,">=95")-COUNTIF(A1:A10,">100")

Watch the > and >= signs of course to make sure they fit ur needs.

 

[Jason Morin]

Several ways:

=COUNTIF(A1:A10,">=95")-COUNTIF(A1:A10,">100")
=COUNT(A1:A10)-SUM(COUNTIF(A1:A10,{"<95",">100"}))
=SUM(COUNTIF(A1:A10,{">=95",">100"})*{1,-1})
=SUMPRODUCT(--(A1:A10>=95),--(A1:A10<=100))

HTH
Jason
Atlanta, GA