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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...

Advantages and Disadvantages of Mesh Topology

Topic: Advantages and Disadvantages of Mesh Topology Mesh Topology In a mesh topology, every device on the network is physically connected to every other device on the network. Therefore, data can be sent on several possible paths from source computer to destination computer. Mesh topology is more reliable with better performance. Mesh Network Topology is mostly used in wide area networks where reliability is important. Advantages of Mesh Network Topology 1. Since, there are many links to transfer data, Mesh topology gets rid of the traffic problem . Data may be transferred through different links. 2. If one link becomes unusable, it does not disturb the whole system . Other links can be used for communication. 3. Since each node has physical connection with other nodes, therefore, one node can transfer data to many nodes at the same time. Disadvantages of Mesh Network Topology 1. It is very expensive due to implementation of multiple links for each no...

Explain Data Processing Cycle and Main Activities of Data Processing Cycle

After collecting data, it is processed to convert into information. The data is processed again and again until accurate result is achieved. This is called data processing cycle . Data processing cycle involves following three basic activities: Major Activities Involved in Data Processing Cycle Explain Data processing cycle 1. Input 2. Processing 3. Output 1. INPUT It is the process in which collected data is given to computer after converting into binary form. Input step can be further divided into following steps: i) Planning Here objectives of data processing are defined. For example, in examination system, objective is to process student examination data to get result cards. ii) Data Collecting Here data is collected. Data is the raw material for data processing. This must be accurate for getting accurate results. iii) Input Here data is entered into computer. iv) Verification Here collected data is verified to determine whether it is valid for ...