Functions
SUMIFS
Sum cells where all criteria match
When to use it
When should I use SUMIFS instead of SUMIF?
Use SUMIFS to total values that meet several conditions at once; use SUMIF when you only have one condition.
Which argument does SUMIFS actually add up?
The first argument is the sum range; every range/criteria pair after it filters which of those values get added.
Used in
Syntax
SUMIFS(sum_range, range1, criterion1, ...)