countif help

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
 
A

Alex Delamain

I think Don might have cross-posted, but the function is the same!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
countif on multiple criteria 1
Excel Countif Function - Calculating Between Two Sets of Values 3
MS Excel Function (Find Duplicate values) 3
Countif, index and match 2
Finding the weighted average of text that have been given values 1
Cell data entering slow! 0
Need help with using Month as criteria for SUM(COUNTIFS(... 3

Top