» 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:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Accounting Principles, with CD, 6th Edition
- Windows XP Pocket Reference
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Excel VBA Programming for the Absolute Beginner
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
