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






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