Most used functions in excel
by

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

2. SUM

SUM function in Excel adds all values in a range of cells.

sum function

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

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

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

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

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

8. MIN

The MIN function in Excel returns the minimum value from a series of numbers.

MIN function

9. MAX

The MAX function in Excel returns the maximum value from a series of numbers.

MAX function

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

2 of 10 finished! Recommending more on Formulas and Functions: Next Example >>
<< Previous Example | Skip to Next Chapter 07: Find and Select