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

advanced.excel - excel sum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Excel2007: sum

advanced.excel - Excel2007: sum

ResolvedVersion Standard

Siqing has attended:
Excel Introduction course
Excel Advanced course

Excel2007: sum

how to add up the numbers in two cells that are not next to each other?

RE: Excel2007: sum

use "," instead of ":"

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.