AutoSum

Hello Billy,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding AutoSum.

There are several ways in which you can use Autosum.

1.
Click on the cell where you want to the answer to appear. Then click on the SIGMA or backwards E on the toolbar. This will insert the SUM formula, and assume a range of cells to add up. Edit the range if required.
Press Enter

2. If you have multiple columns to add, simply highlight the cells in which the answers will appear, and then click the AutoSum button. This will automatically create the sums, and the answers willl immediately appear.
Check that the ranges are correct

3.
You can highlight the cells you want to add together, including the cell that will contain the answer, and then hit the AutoSum button. This will create the formula in the blank cell.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer