How to Use Sum | Autosum | Max | Min | Average in Excel?

In the previous post, we saw “How to Split Text into Different Columns in Excel?“, now we will see “How to Use Sum | Autosum | Max | Min | Average in Excel?”

Table of Contents hide

Sum Formula

Sum formula is used everywhere in excel. The SUM formula adds values, with the help of sum formula you can add individual values, cell references or ranges, or a mix of all three.

For Example:

=SUM(A5:A50) this will add values in cells A5:A50

To sum the numbers start with =Sum press the Tab key and select the range or cell after that press the “Tab” key again and the sum will be calculated like this:

Try your self:

For Exercise Download

How to Do AutoSum?

With the help of “AutoSum” you can automatically add it.

From Formula Tab:

Place the cursor where you want to Autosum and go to the “Formula” tab click on the “Σ” icon and press the enter button…

Via Shortcut Key:

place the cursor where you want to do Autosum and press “ALT + =” key. Lets see…

Note: This “ALT+ =” key will work till the continuity of the data, which means it will add values to continuous data else it will stop like this:

Max Formula

Returns the largest value in a set of values. It ignores logical values and text.

Syntax: =MAX(number1, [number2], …)

With the help of the same example, we can calculate the maximum number of mobiles sold in different years. To do that place the cursor where you want to calculate maximum value press =Max press Tab key select the range and again press the Tab key, so let’s see…

Min Formula

Min function returns the smallest number in a set of values. It ignores logical values and text.

Syntax: MIN(number1, [number2], …)

With the help of the same example, we can calculate the minimum number of mobiles sold in different years. To do that place the cursor where you want to calculate minimum value press =Min press Tab key select the range and again press the Tab key, so let’s see…

Average Formula

The average formula returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.

Syntax: =AVERAGE(number1, [number2], …)

Place the cursor where you want to calculate average press =Average press Tab key select the area again press Tab key. Let’s see…