countif help

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

How do I use countif to select between numbers. If I have a column of
numbers and I want to find numbers greater than, lets say, 100 and lower
than 200. Would I have to use AND? Is there an ANDCOUNTIF formula or can I
add more to this formula?
=COUNTIF(A1:A30,">100") Here is where I get lost.
Thanks,
Ken
 
I think Don might have cross-posted, but the function is the same!

=SUMPRODUCT((A1:A30<200)*(A1:A30>100)
 
Back
Top