excel
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

# Excel

Resolved · Low Priority · Version 2010

Fri 25 May 2012, 14:24Delegate Carmen said...

Carmen has attended:
Excel Introduction course

### Excel

Could you explain the sum function

For upcoming training course dates see:

Tue 29 May 2012, 15:32Trainer Rodney said...

### RE: Excel

Hello Carmen,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding the SUM function.

Let's begin with the Syntax of the function which is as follows:

=SUM(Number1,Number2,Number3,.......)

If number1 was 20, number2 was 30, number3 was 10 then the SUM function adds these three numbers together giving you an answer of 60.

The SUM function also works with a range of cells:

=SUM(A12:A50)

The above example will add all the values in the cells from A12 to A50. So, if you have a column of numbers (called a range), click the empty cell below this range and press = then type SUM(

Then select the range and press enter.

You can also use the AutoSum button (found on the Home or Formulas ribbons) which will do the range selection for you. Just make sure that when using AutoSum that it does select the correct range.

Give this a try!

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,

Rodney
Microsoft Office Specialist Trainer

Tue 5 Jun 2012: Automatically marked as resolved.

microsoft+excel+training+london and other Microsoft training courses.

### Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips

MS Project training
 Course rating: 4.8 stars - based on 5149 reviews