How to Use Excel SUMIF Function (Examples + Video)

Excel SUMIF Function (Example + Video)

Excel SUMIF Function

When to use Excel SUMIF Function

SUMIF function can be used when you want to add the values in a range if the specified criteria is met.

What it Returns

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

Syntax

=SUMIF(range, criteria, [sum_range])

Input Arguments

  • range – the range of cells against which the criteria is evaluated. It could be numbers, text, arrays, or references that contain numbers.
  • 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.

Additional Notes

  • Adds values based on single criteria. If you want to add based on multiple criteria, use SUMIFS function.
  • If sum_range argument is omitted, Excel uses the criteria range (range) as the sum range.
  • Blanks 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.
  • If the size (number of cells) in criteria range and sum range are different, the size of criteria range takes precedence.

Excel SUMIF Function – Live Example

Excel SUMIF Function – Video Tutorial

You may also like the Following Excel Tutorials:

Related Excel Functions:

Excel Ebook Subscribe

FREE EXCEL BOOK

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

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

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

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

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

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

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

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