Excel Function List: 10 Commonly Used Functions in Excel

8.8 min read|Last Updated: February 13th, 2024|Categories: excel|
table of content

Excel is a useful tool for everyone, from making a simple list to doing complicated math, there is nothing you can’t do on this handy application. Among all the options that this tool has, Excel functions are the most useful ones because they let you create your form or analytical report more interactive and accurate. Here is the list of the most common Excel functions.

10 most used Excel functions

Here’s a list of 10 most used Excel functions

Excel Count Function 

If you want to know how many cells contain data in your spreadsheet, you can use the COUNT function. However, you should know that the simple COUNT function only checks the cells for numeric data, so if the cells contain text or formula, they’ll not be counted.

To count all the cells in a range containing any type of data (text, numbers, formula, etc.), you can use the COUNTA function, which counts all the cells except the blank ones.

In case you are looking to count the blank cells, the blank cells, you can use the COUNTBLANK function.

There is another counting function which helps you count the cells that have a specific condition. Using the Excel COUNTIF function, you can set a condition and count specific cells having that condition. For example, you want to know how many cells contain a particular text such as “Good”, or how many cells have numbers that are higher than “7”. So, you have two parts in this type of function, one specifies the range and the other specifies the condition. The formula will be as follow:

The result of all types of count functions will be a number, which will be displayed on the cell that contains the formula.

Example of Excel COUNTIF Function usage
Figure 1- Example of Excel COUNTIF Function.

Please note that the COUNT function is different from the SUM function, which will be explained next. 

Excel SUM Function

One of the most common and frequently used functions in Excel is the SUM function, which helps you easily calculate the numeric data in cells. The simplest way to calculate numbers in a row or a column is by clicking on AUTOSUM on the Home tab. However, it’s also possible to calculate numbers that are in different rows using the SUM formula and “+” sign, check out the following formula:

Example of Excel SUM Function usage
Figure 2- Example of Excel SUM Function.

In this method, you only need to select the cells that you want to calculate.

Excel AND Function

AND function is a logical function that checks multiple statements. If all conditions are TRUE, it will return “TRUE”, but even if one condition is false, the result will be “False.” Check the following statement:

AND (A2>10, A2<20)

It means it returns TRUE if A2 is 15, but it will return FALSE if it is 21.

AND function can be used in combination with other functions such as OR, IF. Since it can check multiple conditions, it’s mostly like the IFS function and they can be used interchangeably. So, if your version of Excel is old and you don’t have an IFS function, you can use the AND function as the logical test inside the IF function to avoid extra nested Ifs.

Example of AND Function in Excel
Figure 3- Example of AND Function.

Average Function

This is one of the extremely useful and also simple tools which helps you find the average value between a range of numbers. The function has several functions in its heart because generally finding the average value needs various processes. Usually, the numerals are calculated first and will be divided into the number of cells. But, with the Average function, none of the steps are needed because it does all the steps in a blink of an eye.

Like all other Excel functions, the AVERAGE function starts with an “=” sign in the cell or the address bar. Then you can add the formula by writing the wo