Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training excel vba - Sum function

Resolved · Low Priority · Version Standard

Reply Mon 12 Feb 2007, 09:41Delegate Michelle said...

Michelle has attended:
Excel Intermediate course

Sum function

How do you use the sum function?

For upcoming training course dates see: Pricing & availability

Reply Mon 12 Feb 2007, 14:58Trainer Amanda said...

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 articles

· Tips From Excel's 'Rarely Used' File
· How To Create An Excel Formula Using Data From Several Worksheets
· Chart Creation Simplified - in 4 Simple Steps
· Excel: Save Time With AutoFill
· Say It With Ribbon

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips