excel.training.course.london - sums
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.training.course.london - Sums

excel.training.course.london - Sums

resolvedResolved · Low Priority · Version Standard

replyReply Wed 5 Dec 2007, 09:53Delegate 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 ?

For upcoming training course dates see: Pricing & availability

replyReply Fri 7 Dec 2007, 13:34Trainer 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:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

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