Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Math Trigonometry Functions

 

SUMIF calculates the sum of a range that meets a specified criterion

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