Newbie needs help with Works 6.0 spreadsheet

  Trikie 17:52 11 Feb 08
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 08

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 08

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 08

fixed reference.


johnny

  VoG II 18:34 11 Feb 08

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 08

Gotcha. Thanks for that.

  Trikie 20:28 11 Feb 08

Thanks everyone - my entry into another new computer world.

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

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant