How to use Sum formula to find data

How to use Sum formula to find data

Microsoft Excel is a spreadsheet program available in the Microsoft Office Package. MS Excel is used to create Worksheets (spreadsheets) to store and organize data in a table format.

Microsoft Excel is one of the most used software application in the world. Excel have the Powerful Tools and Functions, using it for wide verity of applications across the global IT Companies. It is easy to enter the data, read and manipulate the data. Excel stores the data in a table format in Rows and Columns.

SUM Function in Excel

Sum function in excel is an inbuilt function which is used to sum numerical values present in a range of cells, it is a mathematical formula in excel which can be used by typing =SUM( keyword in the cell where we want the sum to be calculated and then we select the range of cells which are to be added.

How to use INDEX and MATCH

INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH is incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. If you want to improve your Excel skills, INDEX and MATCH should be on your list.

The INDEX Function

The INDEX function in Excel is fantastically flexible and powerful, and you will find it in a huge number of Excel formulas, especially advanced formulas. However, what does INDEX actually do? In a nutshell, INDEX retrieves the value at a given location in a range. For example, let us say you have a table of planets in our solar system (see below), and you want to get the name of the fourth planet, Mars, with a formula.

The MATCH function

The MATCH function is designed for one purpose: find the position of an item in a range.Important: The last argument in the MATCH function is match type. Match type is important and controls whether matching is exact or approximate. In many cases you will want to use zero (0) to force exact match behavior. Match type defaults to 1, which means approximate match, so it's important to provide a value

How to use Sum formula to find data

How to use formula 3 to calculate the price according to the number of days we want to know, if you want to know, watch the video from beginning to end.

Formula

-SUM

-Index

-Match

Please Watching My Video is Below 

 

Design by Vannak Vannaro