⌨ Syntax
SUMIFS(sum_range,criteria_range1,criteria1,[criteria_range2,criteria2],...)
Arguments
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 entered as 32 , ">32" , B4 , "apples" , or "32" .
criteria_range2, criteria2, ...
(optional)
— Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.
▶ Examples
=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom")
=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"To?")
=SUMIFS(A2:A9,B2:B9,"<>Bananas",C2:C9,"Tom")