Skip to main content

Practical Use of SUM Function in Excel Worksheet

What is SUM Function?

The SUM Function is used to add all numbers in a given range of cells and returns the total as a result. The syntax of the SUM Function is as follows:

Syntax 1 of SUM Function in Excel wWorksheet:

 SUM(FirstCell : LastCell)

where FirstCell is the cell reference of the first cell in cell range and LastCell is the cell reference of the last cell in the given cell range to be added.
 For Example: If cells A1,A2,A3,A4 contains 10,20,30,40 respectively then the function =SUM(A1:A4) will give 100.

Learn Practical  Use of SUM function in MS Example with examples
Simple Use of SUM function in MS Example with examples

Syntax 2 of SUM Function in Excel Worksheet:

  SUM(number1, number2, number3, ..., number N)
    For Example:
= SUM(10,20,30)
will give the result 60.   and  = SUM(2,5) will give 7.

Syntax 3 of SUM Function in Excel Worksheets:

 SUM(cell1, cell2, cell3, . . ., cell N)
Where cell1, cell2, cell3,...cell N are the cell references of the cells containing numbers to be added.
 For Example: =SUM(A1, A3,A5) will give 10 if cell A1, A3, A5 have 2,3,5 respectively.
Practical  Use of SUM function in MS Example with examples


There are some more possibilities to use the SUM function as following:
How To Use SUM Function in Excel worksheet

If cells A2:E2 contain 5, 15, 30, 40, and 50 as show in above Excel Worksheet image:  
SUM(A2:C2) equals 50        because 5+15+30
and SUM(B2:E2, 15) equals 150    because 15+30+40+50   and +15

If A1:A4 contains 10,20,30,40 respectively and cell A5 contains a non numeric value like "Excel" then the function = SUM(A1:A5) will return 100 because it ignores non-numeric value in Cell A5 that is Excel.

Example How to Use SUM Function in Excel worksheet

Comments

Popular posts from this blog

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...