Excel Sum Function

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

Resolved · Low Priority · Version 2003

Excel Sum Function

James has attended:
Excel Advanced course

by - delegate James [1 post] (2008 May 14 Wed, 16:35) Reply

How do I sum a column?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel Sum Function

by - trainer Katie gold contributer [214 posts] (2008 May 15 Thu, 12:50) Reply

Hi James,

Thanks for your question.

There are two ways to sum a column of numbers:
1) Click on the cell where you will put the total. Click on the Autosum button Σ, then select the whole column of cells and press Return/Enter.

2) Select the column of numbers first then click on the Autosum button Σ.
TIP: quick way to select a column of data, click on the first cell > press CTRL+SHIFT+ ↓ (down arrow)

See if this helps.

Kind regards,

Katie Woo
Microsoft Certified Trainer

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Tap the Power of Recorded Macros with MS Excel Courses
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Advanced Excel Training - takes you to the next level

Please browse our web site to find out more about
excel vba courses and other Microsoft training courses.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Rate this page: