» Counting the Number of Values Between Upper and Lower Limits
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Finding the number of values in List1 (Column A) that are larger than 20 and smaller than 50.
Solution:
Use the COUNTIF function as shown in the following formula:
=COUNTIF(A2:A7,"">20"")-COUNTIF(A2:A7,"">=50"")
Or use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((A2:A7>20)*(A2:A7<50))
List1
30
10
60
40
15
55
Result 2
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- Financial Statement Analysis with S&P insert card
- Investing in Real Estate, Fourth Edition
- The Analysis and Use of Financial Statements
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
