Countif Criteria

[Wayne K]

I want to specify a range of numbers as the criteria. Example: How many entries in my database fall between 5 and 20

 

[Frank Kabel]

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))

 

[Peo Sjoblom]

One way

=COUNTIF(Range,">=5")-(COUNTIF(Range,">20")

--

Regards,

Peo Sjoblom

I want to specify a range of numbers as the criteria. Example: How many

entries in my database fall between 5 and 20