Counting the number of values between upper and lower limit:

Problem:

Finding the number of values in List1 (Column A) that are larger than 20 and smaller than 50.

Solution:

Use the COUNTIF function as shown in the following formula:
=COUNTIF(A2:A7,"">20"")-COUNTIF(A2:A7,"">=50"")
Or use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((A2:A7>20)*(A2:A7<50))