» Counting the Number of Values from Multiple Worksheets that Match Criteria
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Problem:Counting the total number of values from the range A1:B3 on Sheets 1, 2 & 3 that are greater than the criteria specified in cell A2.
Solution:
Use the SUM, COUNTIF, and INDIRECT functions as shown in the following formula:
=SUM(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!A1:B3"),">"&A2))
Book Store:
Recommended Books:
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Wall Street Journal Guide to Understanding Money and Investing
- Analyzing Markets, Products, and Marketing Plans
- The Basics of Finance: Financial Tools for Non Financial Managers
- Monte Carlo Methods in Finance
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
No comments have been submitted.
