Tip Printed from ExcelTip.com

---

Counting the Number of Values Between Upper and Lower Limits


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

List1
30
10
60
40
15
55

Result 2