Sum cumulatively in any spreadsheet
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