Using Autosum with Microsoft Excel

Posted March 3, 2011 by Chris Luongo in Microsoft Excel

Many people use Microsoft Excel to crunch numbers and keep track of sales. It’s ability to insert and utilizing formulas is incredible. This tutorial and screencast demonstrates Excel’s powerful autosum feature to calculate the sum and the average of a column of numbers.

Autosum is a feature that will pick cells to add for you and write its own formula. In this tutorial I will show you how to use autosum to add numbers and find the average of a list of numbers.

1. Create your spreadsheet and label it respectively with columns and cells open for your calculations to appear in. I have a spot for Total Earned (Month Total) and Total Average (Month Average) for each day of the week. The sums will go in all the cells with red dots.

Excel Autosum

2. To find the Month Total for Monday click once on cell C12.

excel autosum

3. Select the Home tab on the Excel Ribbon and all the way at the right under Editing, click Autosum.

autosum excel

4. You will now see a blue box around the cells that autosum thinks you want to add. If correct, press enter on your keyboard.

autosum

[    =SUM(C7:C11) is the formula autosum automatically creates. It is basically saying this formula equals the sum of cells C7 through C11 if adding ]

5. You should now see a number where we entered our autosum formula. It just added up your columns and create the formula for you.

autosum sum

6. To copy this formula to the other days of the week, right click cell C12, click copy , hold shift key, and click cell G12 (friday).

excel autosum

7. Right click and click paste. The formula will be applied to these cells.

autosum excel

8. We now want to find the average with autosum. Click the cell for Monday next to Month Average.

excel auto sum

9. Go to the autosum button but this time click the drop down arrow and select Average.

autosum average

10. You will notice autosum has only added cell C12 to its formula. This is incomplete and not even what we want to find the average of.

autosum average bad

11. Simply edit the formula in the parenthesis so that is finds the average of cells C7 through C10. The formula is: =AVERAGE(C7:C10)

excel autosum average

12. You now have found the average! Use the same copy and paste method to apply the formula to the other days of the week.

excel autosum average done

 

About Chris Luongo

Chris is a self-taught web designer and developer out of Atlanta, GA. This geek enjoys coffee, cold brews, bike riding, and twisting any form of tech into submission.
View more articles by Chris Luongo

The Conversation

Follow the reactions below and share your own thoughts.

  • Anonymous

    I tried just clicking and draging to select cells while in autosum mode rather than type them in and that works too.

  • Anonymous

    oops, double post

  • Chris Luongo

    Koalakong that works too!

  • CharlieRex

    Dumbest post ever…