How do I get Countif to count the number of occurrences between 95 and 100? Thanks
R Ronbo Dec 21, 2004 #1 How do I get Countif to count the number of occurrences between 95 and 100? Thanks
D Dave R. Dec 21, 2004 #2 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.
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.
J Jason Morin Dec 21, 2004 #3 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
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
