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

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data 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 etc. 2) Data of Citizens During census, data of all citizens is collected. 3) Survey Data Different companies collect data by survey to know the opinion of people about their product. 4) Students Examination data In examination data about obtained marks of different subjects for all students is collected. Different Types Of Data There are following main types of Data. 1) NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...

Bus Topology Advantages Disadvantages

Bus Topology Bus topology is the simplest network topology . In bus topology , all computers in network are connected to a common communication wire. This wire is called BUS. Terminators are used at both ends of wire. Bus Topology is Cheap, easy to handle and implement. Bus Topology require less cable. Bus Topology is best suited for small networks. Working of Bus Topology with Advantages and Disadvantages Advantages of Bus Network Topology 1. It is very simple topology . 2. It is easy to use. 3. It needs small amount of wire for connecting computers. 4. It is less expensive due to small wire needed. 5. If one computer fails, it does not disturb the other computers in network. Other computers will continue to share information and other resources with other connected computers. Disadvantages of Bus Network Topology 1. Only small number of computers can be connected in a bus network . 2. Network speed slows down as the number of computer increases in b...

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, ...

Perfect Computer Notes

Search This Blog