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

2 minutes, 2 seconds Read


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?”

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:


How to Do AutoSum?

Advertisements

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…


For Latest Updates & Learning Join Our YouTube Channel: Join Now

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock