G Guest Mar 3, 2004 #1 I want to specify a range of numbers as the criteria. Example: How many entries in my database fall between 5 and 20
I want to specify a range of numbers as the criteria. Example: How many entries in my database fall between 5 and 20
F Frank Kabel Mar 3, 2004 #2 Hi if you want to check column A try =COUNTIF(A1:A1000,"<20")-COUNTIF(A1:A1000,"<=5") or =SUMPRODUCT((A1:A1000>5)*(A1:A1000<20))
Hi if you want to check column A try =COUNTIF(A1:A1000,"<20")-COUNTIF(A1:A1000,"<=5") or =SUMPRODUCT((A1:A1000>5)*(A1:A1000<20))
P Peo Sjoblom Mar 3, 2004 #3 One way =COUNTIF(Range,">=5")-(COUNTIF(Range,">20") -- Regards, Peo Sjoblom Wayne K said: I want to specify a range of numbers as the criteria. Example: How many Click to expand... entries in my database fall between 5 and 20
One way =COUNTIF(Range,">=5")-(COUNTIF(Range,">20") -- Regards, Peo Sjoblom Wayne K said: I want to specify a range of numbers as the criteria. Example: How many Click to expand... entries in my database fall between 5 and 20
