Hi Is there and way to use countif to count a range with numbers between two values. Erle
E Erle Feb 16, 2004 #1 Hi Is there and way to use countif to count a range with numbers between two values. Erle
P Peo Sjoblom Feb 16, 2004 #2 Yes =COUNTIF(Range,">=10")-COUNTIF(Range,">20") will count numbers 10-20
