what is the formula for autosum in excel

In Microsoft Excel Autosum tab/button use for multipurpose tools. When you want to total a particular row or column you can use this function. When you just click on AutoSum, Excel automatically enters a formula and immediately gives the result. For example, if you want to A1 to A12 sum/total select the range and click on auto sum it automatically insert total on A13 column =SUM(A1:A12).

how to use autosum in excel 2007

When you click on auto sum drop-down small arrow here also you can find other formulas like Average, Count Number, Max, Min.

Autosum tab more formula 

Average Formula:

To get the average from all the value uses the average function. For example, if a row or column contains 1,2,3… to 12 number, the sum of these number come 78 and when divided by total number than average come 6.5. In this way, the average formula works.

Min Formula:

To find the minimum value from a set of numbers, use the MIN function.

Select the cell where you want the result to appear and click on Min.

Max Formula:

To find the maximum value from a set of numbers, use the MAX function.

Select the cell where you want the result to appear and click on Max.

Count Number:

Count Numbers can be used to find out how many cells contain value/text. Count number formula counts the cell and gives the result. For example, if you put the value/text in larger columns or rows and you want to find how many columns or row contain on data count number formula automatically count row/column and provide results.

Average,count number,max,min formula

If you want to get the smallest 3 values apply the formula =SMALL(B2:F10,1)&", "&SMALL(B2:F10,2)&", "&SMALL(B2:F10,3)

If you want to get the largest 3 values apply the formula =LARGE(B2:F10,1)&", "&LARGE(B2:F10,2)&", "&LARGE(B2:F10,3)