Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11The SUM function (sums) in Excel
Sum in Excel is essential in calculating and processing your data, so the SUM and SUMIF functions are used a lot by you. But for those of you who are new to Excel spreadsheets, you probably don't fully understand these two functions.
The article details instructions on how to use the SUM and SUMIF functions to calculate totals in Excel spreadsheets.
1. The SUM function.
Description
The SUM function helps you to sum arguments. Arguments can be a range, cell reference, formula, etc.
Syntax
SUM (number1, [number2], .)
Where: number1, number2 are the arguments to be calculated, the maximum number of arguments is 255.
Attention:
- The cell has the value TRUE is 1, FALSE is 0.
- If an argument is an array or reference, only numerical values are counted. Any other values in the array or reference are ignored.
For example, for the following table, ask to calculate the total salary of all employees.
Use the SUM: = SUM function (F5: F11) .
The following results:
2. The SUMIF function.
Description
The SUMIF function is a conditional sum function, you can sum arguments according to a given condition.
To sum cells based on multiple conditions, you can use the SUMIF function.
Syntax
= SUMIF (range, criteria, [sum_range])
Inside:
- range: the container containing the evaluation condition. Cells in the range must be numbers or names, arrays, or references that contain numbers, blank values, and ignored text values.
- criteria: conditions for range. Conditions of text, logical symbols, maths must be enclosed in quotation marks and numerical conditions are not needed.
- sum_range: the area to sum based on conditions. If you sum the cells in the range then sum_range you can ignore.
Example: For the following data sheet, request:
- Calculate the sum of all Wages provided that the Salary is> 5500.
- Calculate the sum of all Wages provided that the gender is Female.
Request 1: Use the SUMIF function : = SUMIF (F5: F11, "> 5500") .
The following results:
Request 2: Use the SUMIF: = SUMIF function (C5: C11, "Female", F5: F11) .
The following results:
Very simple, you can use the SUM and SUMIF functions to sum. For each processing request you should use the function accordingly. Good luck!
Isabella HumphreyYou should read it
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- How to use the LEN function in Excel
- How to use COUNTIF function on Excel
- How to use the MOD function and QUOTIENT function in Excel
- How to use MID functions to get strings in Excel
- How to use Excel's VALUE function
- How to use the WRAPROWS function in Excel
May be interested
- How to use the WRAPROWS function in Excel
having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows. - How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
- How to use the NPER function in Excel to plan loans and savingsdo you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.
- How to use the function to delete spaces in Exceldeleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
- How to fix the SUM function doesn't add up in Excelin the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?
- How to use the SUBTOTAL function in Excelthe subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values in excel
- Save time with these text formatting functions in Microsoft Excelmicrosoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many hours of boring and repetitive tasks.
- SUMPRODUCT function in Excel: Calculates the sum of corresponding valuesthe sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.
- How to use the SUMIF function in Excelthe sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.
- How to use the DAVERAGE function in Exceldaverage in excel is a function that calculates the average value of data with given conditions in a spreadsheet. so, how to use this function?
Numbering in Excel
How to add rows and columns in Excel
Create Hyperlink in Word
Change the background image and background in Word
Capture and edit images in Word
Create Watermark for Word documents