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

Labels:

Comments

Post a Comment

Popular posts from this blog

Uses Of Computer In Education Field

Computer can be used in education in the following ways:  Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual  effects. Computers will be helpful for:                        Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...
1 comment
Read more

Types Of e-Commerce

Types/Categories/Modes of e-commerce. There are three main types of e-commerce as follows: 1) Business To Consumer (B2C) B2C ecommerce consists of selling goods and services to individual consumers. In this type, consumers or customers can visit the website and purchase goods online. The website will have a StoreFront. This storefront will show product details, pictures and a shopping cart. Shopping cart is used to collect items to purchase. Advantages of B2C e-commerce B2C e-commerce has the following advantages: * Shopping can be faster and more convenient. * Offerings and prices can change instantaneously. * Broadband telecommunications will enhance the buying experience. 2) Business To Business (B2B) B2B e-commerce takes place between two businesses. One business provides services to other business. Examples of B2B include: Online Advertisement, recruiting, sales, marketing, technical support and training. For eample, some companies provide online purchasing...
5 comments
Read more

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1.    LAN - Local-Area Network 2.    WAN - Wide-Area Network 3.    MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...
Post a Comment
Read more