» 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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Learn MS Excel 2002 VBA/XML Programming
- Word 2002: The Complete Reference
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
