» 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:
- Accounting the Easy Way
- Excel Charts
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The 22 Immutable Laws of Branding
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
