How to use SUMIFS Function in Excel

How to use SUMIFS Function in Excel2018-11-16T11:23:12+00:00

The SUMIFS function can sum values which meet multiple criteria.

In simple words, you can specify more than one criteria to check and get SUM of values where criteria are matched.

Syntax

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

  1. [sum_range] A range of cells & values which you want to sum.
  2. criteria_range1 A range from which you want to test criteria.
  3. criteria1 A criteria which can be a number, text, expression, cell reference or a function.
  4. [criteria_range2] A range from which you want to test criteria.
  5. [criteria2] A criteria which can be a number, text, expression, cell reference or a function.

Examples

In the below example, we have used three different criteria to check and it has returned the sum of the values which meet those criteria.

excel sumifs function examples 1
excel sumifs function examples with wildcard
  1. The first criteria range is A2:A9 and criterion is in the cell A12 which will only sum cells which have alphabet O.
  2. The second criteria range is B2:B9 and criterion is in cell B12 which will only sum cells which have alphabet P. It will apply to all the cells which met the condition 1.
  3. The third criteria range is C2:C9 and criterion is in cell C12 which will sum cells with any type of value. It will apply to all the cells which met the condition 1 and 2.

Sample File

Remember



Content Protection by DMCA.com

One Comment

  1. […] criteria_range1, criteria1, [criteria_range2, criteria2], …) For more understanding, read referencelink . One point I have observed is that the sum_range should be on the right. Do confirm my […]

Leave A Comment