Most Used Functions in Excel
Functions in Excel make your calculation a lot easier. In this lesson, we are going to show the ten most widely used functions in Excel- COUNT, SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP, MIN, MAX, and SUMPRODUCT.
1. COUNT
COUNT function in Excel counts the number of cells containing numeric values.
![count function](https://overallmoney.com/wp-content/uploads/2022/03/function-1.png)
2. SUM
SUM function in Excel adds all values in a range of cells.
![sum function](https://overallmoney.com/wp-content/uploads/2022/03/sum.png)
Note: Excel ignores cells with character values while executing SUM.
3. AVERAGE
AVERAGE function in Excel calculates the arithmetic mean (aka. simple mean/equally weighted mean) of values in a range of cells.
![average function](https://overallmoney.com/wp-content/uploads/2022/03/average.png)
4. IF
IF function in Excel is a conditional function. It returns a value or performs an action if TRUE and returns or performs another action if FALSE.
![IF function](https://overallmoney.com/wp-content/uploads/2022/03/if-function.png)
5. COUNTIF
COUNTIF function in Excel counts with a condition. For instance, the example below counts how many cells have “BAD” in them.
![COUNTIF function](https://overallmoney.com/wp-content/uploads/2022/03/countif.png)
6. SUMIF
SUMIF function in Excel is also a conditional function that sums the values in cells when some conditions are met. For instance, the example below adds the values in cells that have “good” in them.
![SUMIF function](https://overallmoney.com/wp-content/uploads/2022/03/sumif.png)
7. VLOOKUP
In the example below, the VLOOKUP function finds the comment for the state that has a serial number of 5. Here is the breakdown. First, Excel takes the value 5 (E10) to find a match in the left-most column (column B). Second, it identifies imaginary columns (1, 2, 3, 4) in your defined range (B3:E8). Third, when it finds a match of SL 5, the function returns “BAD” from the comment column (4).
![VLOOKUP function](https://overallmoney.com/wp-content/uploads/2022/03/vlookup.png)
8. MIN
The MIN function in Excel returns the minimum value from a series of numbers.
![MIN function](https://overallmoney.com/wp-content/uploads/2022/03/min.png)
9. MAX
The MAX function in Excel returns the maximum value from a series of numbers.
![MAX function](https://overallmoney.com/wp-content/uploads/2022/03/max.png)
10. SUMPRODUCT
The SUMPRODUCT function in Excel calculates the sum of products of cells in the range. The example below calculates the total cost in cell D10 by multiplying columns C and D and then adding those up. Specifically, 6822 = (1*25) + (1*1200) + (4*450) + (2*1300) + (2*150) + (3*299).
![SUMPRODUCT function](https://overallmoney.com/wp-content/uploads/2022/03/sumproduct.png)
2 of 10 finished! Recommending more on Formulas and Functions: Next Example >> |
<< Previous Example | Skip to Next Chapter 07: Find and Select |