Most Useful & Popular Formulas In Excel You Must Know!

Arrow

average

It returns the average arithmetic value of the arguments.

=AVERAGE (number1, [number2], …) 

Average Formula

Count

It will count the number of cells that contain numbers.

=COUNT(value1, [value2]...)

Count Formula

Sum 

It adds values present in columns or rows.

=SUM(number1, [number2], [number3]……)

Sum Formula

Vlookup

It is used when you need to find things in a table or a range by row.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Vlookup Formula

Min & Max

It allows you to know the highest or lowest value of a set.

=MIN(number1, [number2], …) =MAX(number1, [number2], …)

Min-Max Formula

Want to have an in-depth understanding of the most useful Excel Formulas? We have got you covered!