View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.