Page 310 - Excel 2007 Bible

19_044039 ch14.qxp 11/21/06 11:06 AM Page 267
Creating Formulas That Count and Sum
FIGURE 14.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 14
following formula, entered in cell C2 and copied down the column, is
=IF(B2<>””,SUM(B$2:B2),””)
Figure 14.12 shows this formula at work.
FIGURE 14.12
Using an IF function to hide cumulative sums for missing data.

This workbook is available on the companion CD-ROM. The file is named cumulative
ON the CD-ROM
ON the CD-ROM sum.xlsx.

267