training excel vba - Sum function

The UK's most regular instructor-led training courses.
Training information: training excel vba · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Sum function

Michelle has attended:
Excel Intermediate course

by - delegate Michelle [1 post] (2007 Feb 12 Mon, 09:41) Reply

How do you use the sum function?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: sum function

by - trainer Amanda platinum contributer [947 posts] (2007 Feb 12 Mon, 14:58) Reply

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

· Microsoft Excel Training: Essential for Today's Employees
· Identifying Suitable Candidates For VBA For Excel Training
· Database Tips from an Excel Training Course
· Prepare for your MOS Certification with MS Excel Courses
· MS Excel: Excel At Making The Most Of Your Christmas

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips