Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

How to use SUMIFs Function in Excel?

Duration: 29:38
Submitted: 1 week ago
Views: 33

Comments (0)

Link to this video:

Description: In this video of count and sum formulas, We Will learn the SUMIFs function using different examples with different criteria like Number criteria, Text criteria, Dates criteria, OR AND Criteria in this video.

SUMIFS function is a very powerful function that you can apply to your daily excel life.

checkout the table of contents below to browse through chapters:

Table Of Content:

00:00 Introduction

01:09 SUMIFs Number Criteria

06:49 SUMIFs Text Criteria

13:50 SUMIFs Date criteria

21:16 SUMIFs AND OR Criteria

29:00 Conclusion

Lets Learn the Syntax of SUMIFs function;


The SUMIF function takes three arguments.

range: The range of cells that you want to calculate the sum for.

criteria: The criterion or condition that you want to test each cell in the range against.

sum_range: (optional) The range of cells that you want to include in the calculation, specified as a comma-separated list. If this argument is omitted, SUMIF uses the cells in range as both

the criteria and the sum_range. If this argument is used, it must be a subset of range that does not include any blank or non-numeric cells.

For example: '=SUMIF(A12:G12,'red',B13)'. In this example, SUMIF will return the sum of all cells in range A12:G12 that contain the word 'red'.

Note that you cannot use a named range as part of sum_range. I hope this blog post on count and sum formulas is served to your needs.