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.

SUMIF and SUMIFS functions - specific usage and examples Picture 1

- 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

 

SUMIF and SUMIFS functions - specific usage and examples Picture 2

- 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

SUMIF and SUMIFS functions - specific usage and examples Picture 3

Learning Excel is not difficult, isn't it?Hopefully, the above article will help you apply functions flexibly at work.

4 ★ | 1 Vote

May be interested

  • VLOOKUP function - Usage and detailed examplesVLOOKUP function - Usage and detailed examples
    vlookup 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 examplesPMT function in Excel - Usage and examples
    the 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 examplesExcel date function - Usage and examples
    the 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 PythonThe map () function in Python
    continuing 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 function to use and specific examples
    vlookup 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 ExcelMatrix functions in Excel
    today 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 examplesDCOUNT function in Excel - Usage and practical examples
    the 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 conditionsHow to use the SUMIF function in Excel to calculate the sum based on conditions
    are 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 yet6 useful functions in Google Sheets you may not know yet
    in 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
    offset 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.