Add Numbers and AutoSum Function in Excel

Add Numbers and Autosum Function in Excel

 

 

You can quickly add worksheet numbers by building a formula that uses Excel’s SUM function. Adding a range of numbers is probably the most common worksheet calculation, so it is useful to know how to use Excel’s SUM function.

 

 
Although you can use SUM to add individual cells or a rectangular range of cells, you will most often need to add a row or a column of data. In this case, when you use the SUM function in a formula, you can specify as the function’s argument a reference to either a row or a column of numbers.

Build an AutoSum Formula:

You can reduce the time it takes to build a worksheet as well as reduce the possibility of errors by using Excel’s AutoSum feature. By default, the AutoSum tool adds a SUM function formula to a cell and automatically adds the function arguments based on the structure of the worksheet data.

However, you can also use AutoSum to quickly create simple formulas that use common functions, such as AVERAGE, COUNT, MAX, or MIN.

 

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips