» Summing using multiple criteria in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Row1 adding adding 100
Row2 Advanced Filter 200
Row3 Amortization 300
Row4 Array Formula Array Formula 400
Row5 AutoComplete 500
Formula in cell D1: {=SUM((A1:A5=B1:B5)*C1:C5)}
Result: 500 ( sum the numbers in cells C1+C4)
Please note: The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter
Book Store:
Recommended Books:
- Analysis of Financial Statements
- Microsoft Windows XP Inside Out
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The 11 Immutable Laws of Internet Branding
- 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 Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
