» 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:
No comments have been submitted.

