Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
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:
01:09 SUMIFs Number Criteria
06:49 SUMIFs Text Criteria
13:50 SUMIFs Date criteria
21:16 SUMIFs AND OR Criteria
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.