» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
