Top 5 most useful Excel functions – Maths

Excel offers a wide range of functions which you can in any kind of worksheet. Excel formulas work on Strings as well as Numbers. Lets take a look at some of very useful Mathematical functions in Excel.

In this walkthrough, we will learn the 5 most useful mathematical Excel functions –

  • how to get the sum of a column in excel,
  • how to do an average in excel,
  • how to use the count function excel,
  • min & max function in Excel

Prerequisites

Please Read:

how to get the sum of a column in excel:

As the name suggests, SUM function is used to add any number Cells by typing their addresses. Let’s go through this example:

Lets say you are preparing something like shown in the image. You would want to sum all these numbers in the cell D8. You can Add these values manually and type the result in that cell BUT Excel offers you to Put a formula. That way the Values get calculated automatically, Even if you change them later…

Excel formulas are started with an equal sign or a plus sign if you want to. Type the function below in cell D8.

=SUM(D5,D6,D7)

Explanation:

Lets Split the above formula and Analyze it.

= : Excel formulas are always started with an equal sign (or a plus sign, it depends on your preference)

SUM() : the name of a specific function. Excel has a library full of mathematical and String functions. the name is followed by brackets which is the usual syntax of a formula in excel.

D5,D6,D7 : The Addresses of individual cells, the arguments that this function takes. Excel will take these values, add them and show the result.

You can also define range of cells with a colon. In this case enter D5:D7 to get the same results.

Typing the above formula in D8 Cell will show the SUM as shown in the right.

how to do an average in excel:

You can use the AVERAGE function to calculate an average from the given values, just like the SUM function. To Calculate the Average of Cells A5,A6,A7 , Write:

=AVERAGE(A5:A7)

It will result in.

The example in the right shows the Average expenses.

how to use the count function excel:

You can use the Count function to count the number of values given as an argument( usually as a range).To Count the number of expenses in D8 we can write:

=COUNT(A5:A7)

It will result in.

The example in the right shows the number of expenses.

MIN

We can use the MIN function to find out the lowest value from a range of given values . Write.

=MIN(A5:A7)

It will result in.

min

The example in the right shows the minimum expense in Cell : D8

MAX

We can use the MAX function to find out the highest value from a range of given values . Write.

=MAX(A5:A7)

It will result in.

max

The example in the right shows the maximum expense in Cell : D8

Want to learn some more, Please read:

– ABS function – get absolute value in excel

– All Excel Worksheet Functions

Most useful Mathematical Excel functions:

Leave a Comment