Sum cumulatively in any spreadsheet


Tip
Suppose you have a worksheet like the one shown below.


You want to generate the series of cumulative sums in row 7. In 1-2-3 and Quattro Pro, enter @sum($B$6..B6) in B7 and copy it to range C7..G7. In Excel, enter =sum ($B$6:B6). In this formula, the first cell in the range address is absolute, so it doesn't shift when you copy the formula; the second address is relative, so it changes. As you copy the formula horizontally, each copy sums a progressively bigger range.
- Richard Scoville

Category: Spreadsheet
Issue: Mar 1997
Pages: 184

These Web pages are produced by Australian PC World © 1997 IDG Communications