SUMIF and SUMIFS functions - specific usage and examples
However, some of you still don't know about functions and how to use them, in the following article will explain and have specific examples that are easy to understand for you to quickly grasp these two functions. It will be a great tool to help you handle the job quickly, accurately and efficiently.

- TheSUMIF and SUMIFSfunctions are both conditional sum functions.
However, they differ as follows:
SUMIF : Sum with only one condition.
SUMIFS : Sums two or more conditions.
METHOD OF SUMIF AND SUMIFS
+> SUMIF function:
SUMIF (range, criteria, [sum_range])
The SUMIF function syntax has the following arguments:
- Range : The condition area is the conditional area you want to evaluate.The cells in each cell of the range must be numbers or names, arrays, or references that contain numbers.Blank cell values will be ignored.
- Criteria : Conditions, can be in the form of numbers or expressions.If the condition is in text, you must enclose it in quotation marks ('').
- Sum_range : The total and optional area required by the topic.
+> SUMIFS function:
SUMIFS (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], .)
The SUMIFS function syntax has the following arguments:
- Sum_range : The area to be summed.
- Criteria_range1 : Container condition 1 is the range to be searched according to specific criteria, the area is determined by based on criteria1.
- Criteria1 : Condition 1, criteria that determine which cell in the Criteria_range1 area will be added.
- Criteria_range2, criteria2 : The conditional container 2 is the additional ranges and criteria associated with them.You can enter up to 127 pairs of ranges / criteria.
To better understand, we will go into detail of each function and make specific examples
- SUMIF function:
+ Syntax = SUMIF (Conditional area, condition, Sum area)
For example: Use the SUMIF function to calculate the total bonus for people who are NV
We define the area and condition as follows:
Condition area: Position column
Condition: NV
Area to be summed: Bonus column
- SUMIFS function:
+ Syntax
= SUMIFS (The area to be summed, Condition 1, condition 1, condition 2, condition .)
Still in the example above, required to calculate the total bonus of the NV, gender is Female
We define the area to be summed, the conditional area 1, (2), condition 1, (2) as follows:
Area to be summed: Bonus column
Condition container 1: Position column
Condition 1: NV
Condition container 2: Gender column
Condition 2: Female
Learning Excel is not difficult, isn't it?Hopefully, the above article will help you apply functions flexibly at work.
You should read it
- Differentiate between SUM, SUMIF, SUMIFS and DSUM functions
- How to combine Sumif and Vlookup functions in Excel
- How to use SUMIF with 2 or more conditions in Excel
- How to calculate the total value based on multiple conditions in Excel
- SUMIFS function in Excel
- The way to sum the same codes in Excel
- The SUM function (sums) in Excel
- The SUMIFS function, how to use multiple conditional calculation functions in Excel
May be interested
- VLOOKUP function - Usage and detailed examplesvlookup is one of the most used excel functions. the following article details how to use and detailed examples when using the vlookup function.
- PMT function in Excel - Usage and examplesthe pmt function is one of the built-in financial functions of the excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. the pmt function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
- Excel date function - Usage and examplesthe date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake.
- The map () function in Pythoncontinuing with the topic of built-in functions in python, the article will introduce you to the map () function with syntax, usage as well as specific examples. invites you to read the track.
- VLOOKUP function to use and specific examplesvlookup is one of the most useful excel functions but few understand it. in this article, we will help you understand vlookup with practical examples, such as grading students and staff using the vlookup function.
- Matrix functions in Exceltoday i introduce to you 3 matrix functions commonly used in excel. the article will guide in detail the syntax and specific examples for each matrix function, hoping to help you a lot in your work.
- DCOUNT function in Excel - Usage and practical examplesthe dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
- How to use the SUMIF function in Excel to calculate the sum based on conditionsare you having trouble calculating the sum of values in excel based on conditions? with simple usage, the sumif function will help you calculate accurately.
- 6 useful functions in Google Sheets you may not know yetin this article, i will show you 6 useful functions for the google sheets spreadsheet that you should know such as vlookup, countif, sumif, join, index, ... in addition, you can refer to the functions. and other tips follow the link in the post.
- Offset function in Excel - Usage and examplesoffset function in excel - usage and examples. the offset function in excel is a function of the reference and search function group, the following article will describe the syntax, usage and examples of the offset function in excel, please refer to to understand more about the offset function.