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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Sums

excel.training.course.london - Sums

ResolvedVersion Standard

Wed 5 Dec 2007, 09:53 Delegate Ian said...

Ian has attended:
Excel Introduction course

Sums

How do i add figures up and get a final total at the end of a spread sheet ?

Fri 7 Dec 2007, 13:34 Trainer Katie said...

RE: sums

Hi Ian,

SUM is the function to add a list of figures in Excel.

=SUM(cell 1: last cell)

e.g. if the list is over 3 columns from cell A1 to C10 and the result will show in cell A11. Then in cell A11, you may type:

=sum(A1:C10)

Hope this helps.

Regards,
Katie

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel.training.course.london - Sums

Sums

RE: sums

Excel articles

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook