|  

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

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

Rate This Tip
12 34 5
Rating: 2.61     Views: 69750
No comments have been submitted.
Name
Comment Title
Comments