Microsoft Office Tutorials and References
In Depth Information
Figure 7-13: Simple formulas in column C display a cumulative sum of the values in column B.
The formula in cell C2 is
Notice that this formula uses a mixed reference. The first cell in the range reference always refers to the same
row: in this case, row 2. When this formula is copied down the column, the range argument adjusts so that the
sum always starts with row 2 and ends with the current row. For example, after copying this formula down
column C, the formula in cell C8 is
You can use an IF function to hide the cumulative sums for rows in which data hasn't been entered. The follow-
ing formula, entered in cell C2 and copied down the column, is
Figure 7-14 shows this formula at work.