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.
Search JabSto ::




Custom Search