The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Summing

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

microsoft excel courses - Summing

Resolved · Low Priority · Version Standard

ReplyWed 22 Nov 2006, 15:53Delegate Nikki said...

Summing

how to autosum a row?

For upcoming training course dates see: Pricing & availability

ReplyWed 22 Nov 2006, 16:38Trainer Orok said...

RE: summing

Hi Nikki

To use Autosum button from the standard toolbar, place your cursor where you want the result of the sum calculation to be displayed.

Ensure there is no data in the column immediately above the cursor position.
Ensure there is data immediately to the left of the cursor position; by then selecting Autosum Excel will confirm the summing of the row with "marching ants"

If there is data immediately above the cursor position Autosum will attempt to sum the column, you will then need to manually highlight the range of cells in the row

Excel articles

· Say It With Ribbon
· How To Use Filtering In Excel 2010
· How To Use The Cell Styles Functionality In Excel 2010
· Unsupported features in Excel 2007
· Charting Another Dimension With Excel

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

What do you do if you have forgotten everything and lost confidence that you can use excel?????

» Forum post: Help!

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions