Tip Printed from ExcelTip.com

---

Counting the Number of Values between Two Specified Values in a List


Problem:

Finding the number of values in List1 (Column A) that are between each two successive values in List2 (Column B).

Solution:

To count the numbers in List1 that are, for example, between 1 and 2 (B2:B3), use the COUNTIF function as shown in the following formula:
=COUNTIF($A$2:$A$10,">="&B2)-COUNTIF($A$2:$A$10,">"&B3)