Excel SUMIFS Function with Example

0
314
views

Summary

SUMIFS is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when adjacent cells meet criteria based on dates, numbers, and text. SUMIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Purpose

Sum cells that match multiple criteria
Return value
The sum of the cells that meet all criteria

Syntax

=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …)

Arguments

  • sum_range – The range to be summed.
  • range1 – The first range to evaulate.
  • criteria1 – The criteria to use on range1.
  • range2 – [optional] The second range to evaluate.
  • criteria2 – [optional] The criteria to use on range2.
PropellerAds