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.