» Counting the Number of Values from Multiple Worksheets that Match Criteria
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
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:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Business Plans For Dummies®
- How to Pay Zero Taxes (Annual)
- Excel Charts
- Monte Carlo Methods in Finance
No comments have been submitted.
