Countif between two values
 

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

Thanks

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.

"Ronbo" wrote in message
...
How do I get Countif to count the number of occurrences between 95 and
100?

Thanks

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

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

Thanks
.