Sum

Resolved · Low Priority · Version 2007

Fri 4 May 2012, 16:03 Delegate Joseph said...

Joseph has attended:
Excel Intermediate course
Excel Advanced course

Sum

please remind me how to use the sum function

Tue 8 May 2012, 19:38 Trainer Mark said...

RE: sum

Hello Joseph,

The sum function is used to add totals of a range of cells.
If you have figures in cells A1:A4 and need to total these, you can click in cell A5 (where the answer will go) and click the SUM button. Excel will surround the 4 cells above with "marching ants" to show what it intends to sum up. If you agree with it, just press enter key.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 10 May 2012, 12:09 Delegate Barry said...

RE: sum

There's also another way Joseph.

Here you have a few numbers

20
30
10
40
10
30
30
60
select the cell below them then do Alt+ & hey presto the total will appear.

Baz

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips