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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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