## List of Top 10 Basic Excel Formulas & Functions

Here is the list of Top 10 Basic Formulas & Functions in Excel.

- SUM
- COUNT
- COUNTA
- COUNTBLANK
- AVERAGE
- MIN Excel
- MAX Excel
- LEN Excel
- TRIM Excel
- IF Excel

Now let us discuss each of them in detail –

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked

For eg:

Source: Basic Excel Formulas (wallstreetmojo.com)

### #1 SUM in Excel

This Basic Excel Formula is used to get the sum of the value in one or more cells or Range.

#### Example

**=SUM(A1**:A5**) **

Result = 41 (See Image below)

### #2 COUNT Excel Function

This Basic Excel Function is used to Count the numeric value in one or more cells or Range.

#### Example

**=COUNT(A1:A5)**

Result = 4 (This will exclude Cell A3 since this formula calculate only Numeric value. See Image below)

### #3 COUNTA in Excel

This formula is used to count the value in one or more cells (This will count the cells irrespective of Number or Text value)

#### Example

**=COUNTA(A1:A5)**

Result = 5 (This will Include Cell A3 since this formula calculate both Text and Numeric value. See Image below)

### #4 COUNTBLANK in Excel

This Excel Basic function is used to count the blank value in the Range. (Note: Only Space in a cell will not be considered as a blank cell).

#### Example

**=COUNTBLANK(A1:A5)**

Result = 2 (This will calculate the number of blank cell in Range. See Image below)

### #5 AVERAGE in Excel

This basic formula in excel is used to get the average of the value in one or more cells or Range.

#### Example

**=AVERAGE(A1:A5) **

Result = 4 (See Image below)

### #6 MIN Formula in Excel

This excel basic function is used to get the minimum value in cells or Range.

#### Example

=MIN(A1:A5). Result = 2 (See Image below)

### #7 MAX Formula in Excel

This basic excel function is used to get the maximum value in cells or Range.

#### Example

**=MAX(A1:A5)**

Result = 9 (See Image below)

### #8 LEN in Excel

This basic function excel is used to calculate the number of characters in a cell or Text.

**Example**

**=LEN(A1)**

Cell A1 value is Shivam, which has 6 Character length. So Result would be 6 (See Image below)

### #9 TRIM in Excel

This basic excel function is used to remove unnecessary space in a cell or Text.

**SYNTAX: TRIM(TEXT)**

#### Example

**=TRIM(A1)**

Cell A1 has two spaces between first name, middle name, and last name. This function will remove extra space to give the result. (See Image below)

### #10 IF in Excel

**IF function is used to perform a logical test in excelLogical Test In ExcelA logical test in Excel results in an analytical output, either true or false. The equals to operator, “=,” is the most commonly used logical test.read more.**

**Example**

=IF(A1>33,”P”,”F”). A value in Cell A1 is 50, and a logical test is if the value is greater than 33, then the result would be P else the result would be F.

Since the value 50 is greater than 33, the result would be P. (See Image below)

### Things to Remember

- A formula should always start with equal sign else it will show an error.
- If you are entering any text value instead of giving a cell address, then the text value should be given within Inverted Comma (“”)
- Before entering the function in a cell, make sure that cell format in general. If a Text format is selected, then the formula will not work.
- Space (_) is always counted as a single character so if you are working with blank cells, keep this thing in mind that if a cell has only space, it will not be counted as a blank cell.

### Basic Excel Formulas Video

### Recommended Articles

This has been a guide to Basic Formulas in Excel. Here we discuss the list of top 10 Basic Formulas & Functions in Excel, including SUM, COUNT, COUNTA, COUNTBLANK, MAX, MIN, etc. with a downloadable excel template. You may learn more about excel from the following articles –

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion

Muthu krishnan says

Supper

Chab bob says

Interesting and educative