Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Percentages

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Percentages

Resolved · Low Priority · Version 2007

Reply Mon 20 Dec 2010, 16:19Delegate Yolanda said...

Yolanda has attended:
Excel Intermediate course
Excel Advanced course

Percentages

How to include a percentage figure in a spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Wed 22 Dec 2010, 13:07Trainer Nafeesa said...

RE: percentages

Hi Yolanda

Thank you for your question.

Could you please clarify what you mean by including a percentage figure, do you mean formatting values as percentages or to calculate percentages from values in your spreadsheet.
If you could give me an example of what you are doing that would be a great help.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Tue 4 Jan 2011, 12:29Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 10 Jan 2011: Automatically marked as resolved.

Excel articles

· Excel and Inventory Management
· How To Create A Simple Currency Convertor In Excel 2010
· Why Should I Learn Visual Basic in Excel?
· Identifying Suitable Candidates For VBA For Excel Training
· How To Avoid The Embarrassment Of Dirty Data

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips