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
.
|