» Counting Rows of Even Numbers in Two Parallel Ranges
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: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:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Office XP Introductory Concepts and Techniques
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Excel 2002 Power Programming with VBA
No comments have been submitted.
