excel.training.course.london - sums

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

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

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 ?

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 articles

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.1 secs.