SUM Formula in Microsoft excel

  

SUM

Check below example and try to use in excel in real time for better understanding

Blue text start with "=" is the formula we used

SUM FORMULA

 

What Does It Do ?

This function creates a total from a list of numbers.
It can be used either horizontally or vertically.
The numbers can be in single cells, ranges are from other functions.

Syntax

==SUM(Range1,Range2,Range3... through to Range30).

Formatting

No special formatting is needed.

 Note

Many people use the =SUM() function incorrectly.

This example shows how the SUM has been combined with plus + symbols.
The formula is actually doing more work than needed.
It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).



Comments

Post a Comment

Popular posts from this blog

Large Formula in Microsoft excel

Image
LARGE Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used LARGE FORMULA What Does It Do ? This function examines a list of values and picks the value at a user specified position in the list. Syntax =LARGE(ListOfNumbersToExamine,PositionToPickFrom) Formatting No special formatting is needed.   Example The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar. Note Another way to find the Highest and Lowest values would have been to use the =MAX() and =MIN() functions.
Read more

FREE MICROSOFT EXCEL TUTORIAL / Learn free online Microsoft excel

Image
Introduction to Microsoft Excel What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to analyze data and record number and text. In Microsoft Excel we can use many features like calculations, pivot tables, graphs, automation by macros etc. in Excel columns and rows makes a table. Columns are align it right to left with A,B,C names, and  rows are align in Up to Down in numbers. where column and row meet together is called cell. The cell represent the column and the number together. Where you can get Microsoft Excel? There are number of ways in which you can get Microsoft Excel. You can buy it from a cybercafé or computer shop . Microsoft Excel is part of the Microsoft Office. or you can download it from the Microsoft website and have to purchase it before use. In this Microsoft Excel tutorial, we are going to cover the following topics about MS Excel. How to Open Microsoft Excel? Understanding the Ribbon Understanding the worksheet Customization Microsoft Exce...
Read more

MID Formula in Microsoft excel

Image
   MID Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used MID FORMULA What Does It Do ? This function picks out a piece of text from the middle of a text entry. The function needs to know at what point it should start, and how many characters to pick. If the number of characters to pick exceeds what is available, only the available characters  will be picked. Syntax =MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick) Formatting No special formatting is needed. Example1 The following table uses the =MID() function to extract a post code from a branch ID used  by a company. It is assumed that all branch ID's follow the same format with the letters identifying the  postal region being in the 5th and 6th positions. Example 2 This example shows how to extract an item which is of variable length, which is inside a piece of text which has no standard fo...
Read more