» 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 Screenshot // Summing using multiple criteria in Microsoft Excel