By Laura

- Excel – Dsum function - calculate sum in Excel
- Excel - PRODUCT function for multiplying
- Excel – AVERAGEIF function, calculating average with conditions
- Excel – MAXA function, returning largest value

To better understand the syntax and how to use SUM function in Excel, Betdownload.com will guide you how to effectively use SUM function in many specific cases.

__Excel - How to using the SUM function__*Syntax:* = SUM (number 1, number 2, ...)*Function: *Calculate the sum of number 1, number 2, ect*In which:* number 1, number 2, ect is the number that you want to calculate.

Note:

- the cell with logic value **TRUE **is considered as 1, **FALSE **is considered as 0.

- If the number is a reference, only values in the reference will be counted. The other values are ignored.**Example 1:**

= SUM (1, 2, 3) by 6.

= SUM (2, 3, TRUE) by 6.

= SUM ("2", "3", 1) by 6.**Example 2: **A table of items to be paid:

- Apply SUM function to plus all the money in the Payment column (D4: D6) and put that value in cell D7.

- The formula: D7= SUM (D4: D6) to select all the values from D4 to D6. We have the results as shown below

You have just learnt the SUM function, its operation is extremely simple. Also, you can learn more functions for calculating the sum of available conditions as SUMIF function, ect to perform calculations on a spreadsheet with multiple conditions.

- Related Articles:
- Excel – LARGE function, returning largest value number k
- Excel – Examples and guidance for VALUE function- a function for converting string to number
- Excel - Connect strings having quotation marks, the CONCATENATE function
- Excel – Round function – round number in Excel
- Excel – HLOOKUP function - a search function in Excel
- Excel – COUNTA function – count data cells

Related software

Excel to Image Converter is a program that provides users powerful tools for converting Excel files to JPG/TIFF/BMP/EPS/PS/PNG/PCX effectively with good quality.

- PDF To Excel Converter - PDF to Excel Converter
- Total Excel Converter - Convert Excel to PDF
- Excel to PDF Converter - Converting Excel files into PDF formats

Excel – Examples and guidance for VALUE function- a function for converting string to number

To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will

Excel – AVEDEV function, calculating absolute deviation average

In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve

AVERAGEIFS function, calculating average with multiple conditions

You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without

Excel – AVERAGEIF function, calculating average with conditions

AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and

Excel - PRODUCT function for multiplying

To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and