Excel Tip: Count the number of values between a lower and upper limit in Microsoft Excel / Microsoft Excel Tips / ExcelTip.com

Tip Printed from ExcelTip.com

Count the number of values between a lower and upper limit in Microsoft Excel

To count the number of values between a lower and upper limit in Microsoft Excel, enter the following values in cells A1:A5

A1	65
A2	84
A3	38
A4	25
A5	40

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