The 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.

The SUM function (sums) in Excel Picture 1

Use the SUM: = SUM function (F5: F11) .

The following results:

The SUM function (sums) in Excel Picture 2

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.

The SUM function (sums) in Excel Picture 3

Request 1: Use the SUMIF function : = SUMIF (F5: F11, "> 5500") .

The following results:

The SUM function (sums) in Excel Picture 4

Request 2: Use the SUMIF: = SUMIF function (C5: C11, "Female", F5: F11) .

The following results:

The SUM function (sums) in Excel Picture 5

Very simple, you can use the SUM and SUMIF functions to sum. For each processing request you should use the function accordingly. Good luck!

4 ★ | 1 Vote

May be interested

  • How to use Excel's VALUE functionHow to use Excel's VALUE function
    excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
  • How to use the WRAPROWS function in ExcelHow 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 2016How to use the IFS function in Excel 2016
    the 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 savingsHow to use the NPER function in Excel to plan loans and savings
    do 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 ExcelHow to use the function to delete spaces in Excel
    deleting 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 ExcelHow to fix the SUM function doesn't add up in Excel
    in 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 ExcelHow to use the SUBTOTAL function in Excel
    the 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 ExcelSave time with these text formatting functions in Microsoft Excel
    microsoft 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 valuesSUMPRODUCT function in Excel: Calculates the sum of corresponding values
    the 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 ExcelHow to use the SUMIF function in Excel
    the 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.