» Summing using multiple criteria in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Data in range A1:C5
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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Accounting for Dummies
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Excel 2002 Power Programming with VBA
No comments have been submitted.
