Tip Printed from ExcelTip.com
Summing using multiple criteria in Microsoft Excel


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