SUMIF calculates the sum of a range that meets a specified criterion : SUMIF « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Math Trigonometry functions
3. SUMIF

Input the formula: =SUMIF(A2:A5,">160",B2:B5)

20.51.SUMIF
	20.51.1.	SUMIF calculates the sum of a range that meets a specified criterion
	20.51.2.	=SUMIF(A2:A5,"=30",B2:B3)