sumifs
Sum cells meeting multiple criteria.
Syntax
Section titled “Syntax”v = sumifs(sum_range, criteria_range1, criteria1, ...)Description
Section titled “Description”Sums cells in sum_range where every criteria_range_n matches criteria_n. Multiple criteria combined with logical AND.
Example
Section titled “Example”sumifs(B1:B100, A1:A100, '>0', C1:C100, 'red')See also
Section titled “See also”sumif— Sum cells in a range that meet a criterion.averageifs— Mean of numbers meeting multiple criteria.countifs— Count cells meeting multiple criteria.