» Counting the Number of Values between Two Specified Values in a List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Finding the number of values in List1 (Column A) that are between each two successive values in List2 (Column B).
Solution:
To count the numbers in List1 that are, for example, between 1 and 2 (B2:B3), use the COUNTIF function as shown in the following formula:
=COUNTIF($A$2:$A$10,">="&B2)-COUNTIF($A$2:$A$10,">"&B3)
Book Store:
Recommended Books:
- Microsoft Excel 2002 Simply Visual
- Investing for Dummies, Third Edition
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
