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.
- 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.