Learn Excel Functions: Count, Countif, Sum and Sumif by Rajan

Author:Rajan
Language: eng
Format: azw3
Published: 2015-08-07T16:00:00+00:00

3) Sum Function

In this chapter, you are going to learn how to use Sum Function in excel to sum up the range of cells.

Definition of Sum Function

It is used to add all number in a range of cells and return the result.

Syntax of Sum Function

The syntax of sum Function is given below

Sum(number_1,[number_2,…number_n])

Number_1(mandatory)- It indicate numbers or cell reference or cell range.

Number_2,number_3,..(Optional) – It also indicates numbers or cell reference or cell range.

Data Sheet

It contains the data of marks secured by 10 students in mathematics, English and science subjects. Using this data sheet, we’ll learn how to effectively use the sum function to add marks.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.