» Count the number of values between a lower and upper limit in Microsoft Excel
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
To count the number of values between a lower and upper limit in Microsoft
Excel, enter the following values in cells A1:A5
Enter the lower limit criteria in cell B1: 50
Enter the upper limit criteria in cell B2: 90
Enter the following formula in cell C1: =SUMPRODUCT((A1:A5 > B1)*(A1:A5 < B2))
The result: 2
Book Store:
Recommended Books:
No comments have been submitted.
