Create an AutoSum Formula

One of the most common formulas you will create in Excel is a formula that finds the sum of a column of numbers. Excel enables you to create these formulas called AutoSum formulas, which calculate the sum of values without having to type the formula

1.   Select the last cell of the column or row you want to calculate the total

 

 

 

2.   From the Toolbar, click AutoSum button


 

3.   Make sure that the only numerical values in your column are the ones you want to summarize in your calculation because it will affect the result of the calculation



4.   Press return key

TIP   

  • To use other common functions, such as AVERAGE, MAX, and MIN, click the arrow next to AutoSum

 

  • A green triangle in the upper-left corner of a cell indicates a possible error. To troubleshoot the error, click the cell that contains the error indicator, and then click  for options