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

MS Excel Function (Find Duplicate values) 3
Excel Need Countifs Formula Help 0
Excel Copy COUNTIF while retaining reference 7
COUNTIF function across more than 1 column 0
Adding the value of cells >than 4.5 3
Excel Named Ranges and Conditional Format 3
SUMIF with criteria "<>" & "=" 4
Formulas that compare and sum between worksheets 6

Top