» 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:
- Guide to Financial Reporting and Analysis
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Windows XP Inside Out
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.
