count number of occurances between 2 values

  • Thread starter Thread starter Peters
  • Start date Start date
P

Peters

I am trying to count how many cells contain a number within a certain range
eg number of cells in a column that are between 1000 and 2000.
I thought i could write it like =countif (A1:A4, >1000 <2000) doesn't work
for me
A
1000
4502
1203
2308
 
between 1000 and 2000.

Just so we understand...*between will exclude* from the count both 1000 and
2000.

=COUNTIF(A1:A4,">1000")-COUNTIF(A1:A4,">=2000")
 

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

Excel Need Countifs Formula Help 0
Calculate average in intervals 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Two Criteria COUNTIF 7
Count number of dates between a specified period of time 2
Formula to count data in a column that falls between a range 3
Count Unique Numbers if Names Match 4
how to count if a cell value falls between two numbers 4

Back
Top