"counting" number of entries

  • Thread starter Thread starter Roy Ringrose
  • Start date Start date
R

Roy Ringrose

I'm trying to write a formula that will "count" the number of entries in a
list that are greater than one number but less than another.
 
One way is
=COUNTIF(A1:A20,">="&C1)-COUNTIF(A1:A20,">="&D1)

with lower limit in C1 and upper limit in D1

Another formula -
=SUMPRODUCT(--(A1:A20>=C1),--(A1:A20<D1))
 
Hi,

If you are using 2007 then try:

=COUNTIFS(A1:A10,">1",A1:A10,"<9")

You can also use

=SUMPRODUCT((A1:A10>1)*(A1:A10<9))
 
Back
Top