SUMIFS function

SUMIFS totals the arguments that meet multiple conditions.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

  • sum_range is the range of cells to total.
  • criteria_range1 is the range to be checked by criteria1. Criteria_range1 and criteria1 are search pairs and when items that meet ceriteria1 in the range are found, their corresponding values in sum_range are added.
  • criteria1 is the criteria that defines which cells in criteria_range1 will be added.
  • criteria_range2, criteria2, (optional) are additional ranges and their corresponding criteria. You can enter up to 127 range and criteria pairs.

Example

=SUMIFS(A2:A9, B2:B9, "Female", C2:C9, "An*")

Totals the number of female students whose names start from "An". It uses "Female" to look for matching values in criterial_range1 B2:B9, and looks for the name that starts from "An" in criterial_range2 C2:C9. It then adds the numbers in sum_range A2:A9 that meet both conditions.