SUMIFS function

Category: Math and trigonometry
Introduced: Excel 2007

Summary

Adds the cells in a range that meet multiple criteria

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")

Example

=SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom")
=SUMIFS(A2:A9, B2:B9, "<>Bananas", C2:C9, "Tom")

Microsoft Support Page

https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b

Back to Functions