» Counting the Number of Times Any of the Numbers in First List Appears within Second List
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Calculating the total number of times any of the numbers in List1 (column A) appear within List2 (column B).
Solution:
Use the SUM and COUNTIF functions as shown in the following Array formula:
{=SUM(COUNTIF(B2:B9,A2:A4))}
Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Definitive Guide to Excel VBA
- Special Edition Using Microsoft Word 2002
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
