COUNTIF - Between Two Numbers

D

Dave

From one column of numbers, I want to count if the number
falls within a range (say 500 to 1000).

Thanks,
Dave
 
D

Dan E

For 500 < X < 1000:
=COUNTIF(A1:A100,">500")-COUNTIF(A1:A100,">=1000")
OR
=SUMPRODUCT(--(A1:A100>500),--(A1:A100<1000))

For 500 <= X <= 1000
=COUNTIF(A1:A100,">=500")-COUNTIF(A1:A100,">1000")
OR
=SUMPRODUCT(--(A1:A100>=500),--(A1:A100<=1000))

Dan E
 

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

COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
SUMIF between date range 0
Finding the proper style field and the numbered paragraph value within the style 0
Counting multiple occcurrences between date range 3
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Calculate average in intervals 1
count number of occurances between 2 values 3

Top