Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training excel vba - sum function

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - Sum function

training excel vba - Sum function

ResolvedVersion Standard

Michelle has attended:
Excel Intermediate course

Sum function

How do you use the sum function?

RE: sum function

Hi Michelle

Thanks for your question.

You can enter the sum function into your spreadsheet by selecting the cell where you want your total to appear and clicking on the AutoSum button on the standard toolbar (the AutoSum button looks a bit like an E).

Check the formula that Excel enters into the cell for you - if it is adding together the wrong things, you can either use your mouse to select the cells you wish to add otherwise you can edit the formula so it adds together the cells you want.

If you want to know more look up Autosum in Excel Help.

thanks
Amanda

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.