Another Newbie Works spreadsheet query

  Trikie 22:54 11 Feb 08

Following my query about adding cumulative totals for a route sheet I now want to establish intermediate distance from an existing sheet that only gives the total distance at each instruction. If I enter the totals in Column E how do I get the intermediate distances between each in column A?

I assume it's a variation on the =SUM(A$1:A1) that VoG gave me but I can't find any reference in the Help about this or similar formulae - it only covers AutoCalc which is limited to one line.

  VoG II 09:17 12 Feb 08

In A2 enter


and copy the formula down as before.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 7 simple tips to get more out of…