# Newbie needs help with Works 6.0 spreadsheet

Trikie 17:52 11 Feb 2008
Locked

I have never even looked at the spreadsheet function but now need it and can't find answer in Help (probably there but I can't see where)

I need to build up instructions on a road route, showing intermediate and cumulative distances. I've seen a print of one that I want to copy.

Column A shows the intermediate distance and Column E the running total (B, C and D contain text directions). A1 is blank, being the start point so presumably E1 is entered manually. What is the formula for adding E1 to A2 and displaying it in E2 and so on for 30 columns?

VoG II 17:59 11 Feb 2008

In E1 enter the formula

=SUM(A\$1:A1)

Click in E1 and hover the cursor over the bottom right corner of the cell and the cursor will turn into a +

Hold down the left mouse button and drag the formula down as far as needed.

Pineman100 18:26 11 Feb 2008

VoG - my (cruder) solution would have been:

In E1 enter =A1

In E2 enter =E1+A2 (then replicate E2 down the column as you've described)

Yours is much more elegant - what function does the \$ sign perform, please?

johnnyrocker 18:31 11 Feb 2008

fixed reference.

johnny

VoG II 18:34 11 Feb 2008

The \$ makes A\$1 an Absolute reference - when you drag the formula down the row number won't change. If you wrote \$A\$1 that would also 'fix' the column but that isn't necessary in this case.

Pineman100 18:39 11 Feb 2008

Gotcha. Thanks for that.

Trikie 20:28 11 Feb 2008

Thanks everyone - my entry into another new computer world.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017