excel sum function
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Sum Function

Excel Sum Function

resolvedResolved · Low Priority · Version 2003

replyReply Wed 14 May 2008, 16:35Delegate James said...

James has attended:
Excel Advanced course

Excel Sum Function

How do I sum a column?

For upcoming training course dates see: Pricing & availability

replyReply Thu 15 May 2008, 12:50Trainer Katie said...

RE: Excel Sum Function

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

 

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

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard