Hello friends. Welcome back to the Basic Excel Series for beginners. And today, let’s take a look at the 10 most common functions
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
COUNT function
The COUNT function is used to count how many cells have a numeric value

Can COUNTA be used to count all cells with values
SUM . function
The SUM function has the purpose of calculating the total value of an interval

Note: The SUM function can be used to sum 1 row. Example: =SUM(5:5)
IF . function
The if function checks whether the value is true or false and returns the result

AVERAGE function
The AVERAGE function is capable of calculating the average of cells in Excel

COUNTIF . function
COUNTIF can be used to count with 1 associated condition (in the example below is the value with the word Star in that cell)

SUMIF . function
SUMIF function to sum a certain range with a specified condition

VLOOKUP . function
VLOOKUP is a function used to search for a value based on a given condition

MIN . function
The MIN function is used to find the smallest value of an interval .

MAX . function
The MAX function is used to find the maximum value of an interval .

SUMPRODUCT . function
The SUMPRODUCT function will help us quickly calculate the total amount based on the quantity and price

So I just went through the 10 most common functions in Excel. Leave a comment to let me know what you think!







![[Godot RPG] #4 : Tilemap [Godot RPG] #4 : Tilemap](https://anonyviet.com/wp-content/uploads/2021/02/16-02-2021-11-26-35.png)


