top of page


The SUMIFS function enables us to calculate the sum of values that satisfy multiple criteria. Unlike the SUMIF function (without an "S" at the end), the sum range and criteria range must be specified separately in the SUMIFS function.

The syntax of this formula is: 

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], [criteria_range3, criteria3], …)

  1. sum_range – The range we’d like to sum (only for the cells that matched the multiple criteria). 

  2. criteria_range 1 – The first range in which criteria1 is checked. 

  3. criteria1 – The first criteria that is checked 

  4. criteria_range 2 – The second range in which criteria2 is checked. 

  5. criteria2 – The second criteria that is checked.

Please note that criteria_range2 onwards are optional criteria.

bottom of page