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

training in excel - sum

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

training in excel - Sum

ResolvedVersion Standard

Jemma has attended:
Excel Intermediate course

Sum

How do you do a sum function?

RE: sum

Hi Jemma

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:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

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.09 secs.