ExcelBanter - "counting" number of entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "counting" number of entries (https://www.excelbanter.com/excel-worksheet-functions/224964-counting-number-entries.html)

Roy Ringrose

"counting" number of entries

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.

Sheeloo[_4_]

"counting" number of entries

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

"Roy Ringrose" wrote:

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.

Shane Devenshire[_2_]

"counting" number of entries

Hi,

If you are using 2007 then try:

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

You can also use

=SUMPRODUCT((A1:A101)*(A1:A10<9))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Roy Ringrose" wrote:

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.

All times are GMT +1. The time now is 10:24 PM.