» Creating a Counting Grid
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Range A2:B7 contains the letters A to C and a corresponding number from 0 to 5. Each combination can appear any number of times.
Range D3:D6 contains the letters A to D. The numbers 0 to 5 are listed in cells E2:J2.
We want to create a formula that will count the number of rows in the range A2:B7 containing each letter-number combination shown in the range D2:J6.
Solution:
Use the SUMPRODUCT function as shown in the following formula and enter it in cell E3, then copy the formula to the entire grid (cells E3:J6):
=SUMPRODUCT(($A$2:$A$7=$D3)*($B$2:$B$7=E$2))
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Understanding Financial Statements
- Microsoft Outlook 2002 for Dummies
- 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 South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
