How to Use Excel SUMIFS Function (Examples + Video)

Excel SUMIFS Function (Example + Video)

Excel SUMIFS Function

When to use Excel SUMIFS Function

SUMIFS function can be used when you want to add the values in a range if multiple specified criteria are met.

What it Returns

It returns a number that represents the sum of all the numbers for which the specified criteria are met.

Syntax

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

Input Arguments

  • range – the range of cells against which the criteria is evaluated. It could be numbers, text, arrays, or references that contain numbers. Blank and text values are ignored.
  • criteria – the criteria that is checked against the range and determines which cells to add.
  • sum_range – (optional) the cells to add. If this argument is omitted, it uses range as the sum_range.
  • [criteria_range2] – (optional) the range of cells against which the criteria2 is evaluated.
  • criteria2 – the criteria that is checked against the criteria_range2 and determines which cells to add.

Additional Notes

  • Adds values based on multiple criteria.
  • Blanks and/or text in sum_range are ignored.
  • Criteria could be a number, expression, cell reference, text, or a formula.
  • Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes.
  • Wildcard characters can be used in criteria.
  • Criteria should not be longer than 255 characters.
  • Cells in sum_range are added only when all the conditions are met.
  • Cells in the sum_range argument that contain TRUE evaluate to 1; cells in sum_range that contain FALSE evaluate to 0 (zero).
  • Size of sum_range and all the criteria_range must be equal.

Excel SUMIFS Function – Live Example

Excel SUMIFS Function – Video Tutorial

Related Excel Functions:

Related Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

2 thoughts on “How to Use Excel SUMIFS Function (Examples + Video)”

  1. How to add values when criteria is date, suppose that we have value in order of dd-mm-yyyy and we want to add only a particular months value.please help me

    Thank you

    Reply

Leave a Comment