"counting" number of entries

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.
 
S

Sheeloo

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))
 
S

Shane Devenshire

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))
 

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

Multiple countif lookup 2
Counting 2
Excel - count if a number falls within an array in a column & add 3
Excel Need Countifs Formula Help 0
count for numbers >one and < another in a row of cells 9
Check number within a range 2
Excel Formula 2
I am using the COUNT function to determine the 1

Top