» Counting Rows of Even Numbers in Two Parallel Ranges
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Counting the number of times that a row has an even number in both columns A and B.
Solution:
Use the SUMPRODUCT and MOD functions as shown in the following formula:
=SUMPRODUCT((MOD(A2:A7,2)=0)*(MOD(B2:B7,2)=0))
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- Business Plans Kit for Dummies (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Understanding Financial Statements
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
