Count if a number is between X and Y

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?
 
In another column insert the test formula: =AND(A1>250, A1<2000), then count
the number of cells in that column containing TRUE.
 
=COUNTIF(A:A,"<2000")-COUNTIF(A:A,"<250")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You could get there with sumproduct, but countif can handle it in two steps:
=countif(a:a,">250")-countif(a:a,">=2000").
 
Back
Top