Contents
Excel Formulas You Need To Know
SUM
One of the most basic calculations we frequently do with our numbers is that the sum process. An example in work will be once we have to sum all the revenues we get from all products. or even after we want to understand the overall inventories we’ve currently in our warehouse.
If you’ve got all those numbers you would like to feature in excel, then SUM can make quick work for you. Just input all of your numbers within the formula and enter. You may get your sum result immediately!
AVERAGE
When processing numbers, calculating their average is additionally sometimes essential to urge the results we want.
We can use this calculation type for several use cases. Things like knowing what quantity profit we usually make daily or our estimated production capacity are two examples from many. If we process our numbers in excel, then we are able to use the typical formula to average them fast. Like SUM, just input all the numbers you wish to average and enter. You’ll get the typical of these numbers immediately as a result.
COUNT
The function COUNT counts the entire number of cells in an exceedingly range that contains variety. It doesn’t include the cell, which is blank, and also the ones that hold data in the other format except numeric.
As seen above, here, we are counting from C1 to C4, ideally four cells. But since the COUNT function takes only the cells with numerical values into consideration, the solution is 3 because the cell containing “Total Sales” is omitted here.
If you’re required to count all the cells with numerical values, text, and the other format, you need to use the function ‘COUNTA()’. However, COUNTA() doesn’t count any blank cells. To count the amount of blank cells present in an exceedingly range of cells, COUNTBLANK is employed.
IF
Need the comparison results of some numbers to their targets or want to label your spending posts supported their certain spending limits? The IF formula will be your succor in doing those types of works.
When using IF, you would like to input a logic condition, the result if it’s true, and therefore the result if it’s false. you wish to check both numbers in your logic condition. When your comparison is correct, you’ll be able to produce a specific text, as an example, to label the result. When it isn’t correct, you label it with a special quite text.
As you regularly must do comparison processes when processing data, this IF formula are some things you must master. Doing so should make your job much easier to complete after you work together with your data in excel.
VLOOKUP/INDEX MATCH
When we have multiple worksheets or data tables in excel, at some point you’ll have to consolidate that data. Thankfully, there are formulas which will help us to lookup data, which are VLOOKUP and therefore the INDEX MATCH combination.
To use this powerful combo, we just must supply our lookup reference and where they ought to find the info. they’ll automatically pull the information supported those inputs.
Between the two, many people probably use VLOOKUP for his or her data lookup process. However, if you can, you must learn the way to use the INDEX MATCH formulas combination too. It’s far more flexible in its process and result compared to VLOOKUP.
SUMIFS
Having some criteria for the numbers you would like to sum in Excel? If you are doing, then you’ll use the formula that Excel provides to try and do that sort of calculation, SUMIFS. In SUMIFS, you wish to input your numbers cell range, the cell ranges which your criteria will evaluate, and your criteria. SUMIFS will only sum the numbers from the info entries which meet all of your criteria.
When you have many data entries you would like to sum your numbers selectively, this formula will surely become useful.
