» 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:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Accounting for Dummies
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Microsoft Access Version 2002 Step by Step
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
