G Guest Mar 6, 2007 #1 I´ve a list of numbers and want to use the count how many of this is within the ranges
G Guest Mar 6, 2007 #2 Checks the range A2 - A10 for numbers >=5 and <=20. =COUNTIF(A2:A10,">=5")-COUNTIF(A2:A10,">20") Mike
Checks the range A2 - A10 for numbers >=5 and <=20. =COUNTIF(A2:A10,">=5")-COUNTIF(A2:A10,">20") Mike
G Guest Mar 6, 2007 #3 Hi: Another way to do it is sumproduct: =sumproduct(--(A2:A10>=5),--(A2:A10<20))
