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

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 other facilities in the

Important Objective Type Questions 101-155

MMC stands for multimedia card. SD stands for secure digital card. System Bus is used to connect main components of a computer such as cpu and main memory. A Port is an interface or a point of attachments. POS stands for Point Of Sale terminal. ATM stands for Automated Teller Machine. PIN stands for Personal identification number. Kbps stands for kilobits per second. Mbps stands for megabits per second. A port that transmits one bit at a time is called Serial Port. A type of port that transmits many bits at a time is called Parallel Port. LPT stands for Line Printer. Examples of system software are Operating System, Utility Programs and Device Drivers. Examples of operating systems are DOS, Windows, Unix and Linux. Examples of Utility programs are File Manager, Image Viewer, Disk Scanner and File Compressor. Software used to detect and remove viruses is called Antivirus . Examples of antivirus programs are Mcaffee, Avast,

Advantages and Disadvantages of Ring Network Topology

Topic: Advantages and Disadvantages of Ring Network Topology alongwith detailed working of Ring topology What Do You Mean by Ring Topology? In Ring topology, each computer is connected to the next computer such that last computer is connected to the first. Every computer is connected to next computer in the ring. Each computer retransmits what it receives from the previous computer. Suppose, computer A needs to send data to computer D. Now the computer A sends data to computer B. As computer B is not the destination computer, so it will retransmit data to computer C. Finally, Computer C will transfer data to computer D, the destination computer. When a node sends a message, the message is processed by each computer in the ring. If a computer is not the destination node, it will pass the message to the next node, until the message arrives at its destination. Advantages of Ring Network Topology 1. It is relatively less expensive than a star topology network. 2. In a Rin

Perfect Computer Notes

Search This Blog