Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sum

ResolvedVersion 2007

Joseph has attended:
Excel Intermediate course
Excel Advanced course

Sum

please remind me how to use the sum function

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

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

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.