» 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:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Microsoft Outlook 2002 for Dummies
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Windows XP Step by Step (With CD-ROM)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.


