Excel 2010 Bible

Chapter 13: Creating Formulas That Count and Sum

301

range argument adjusts such 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)

FIGURE 13.11

Simple formulas in column C display a cumulative sum of the values in column B.

You can use an IF function to hide the cumulative sums for rows in which data hasn’t been

entered. The following formula, entered in cell C2 and copied down the column, is

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

Figure 13.12 shows this formula at work.

FIGURE 13.12

Using an IF function to hide cumulative sums for missing data.