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

=SUM(B$2:B2)

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

=SUM(B$2:B8)

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

=IF(ISBLANK(B2),””,SUM(B$2:B2))

Figure 7-14 shows this formula at work.