SUMIFS function
SUMIFS function The SUMIFS function, one of the math and trig functions , adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value. Syntax SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) =SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom") =SUMIFS(A2:A9,B2:B9,"<>Bananas",C2:C9,"Tom") Argument name Description Sum_range (required) The range of cells to sum. Criteria_range1 (required) The range that is tested using Criteria1 . Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added. Criteria1 (required) The criteria that defines which cells in Criteria_range1 will be added. For example, criteria can be enter