Page 308 - Excel 2007 Bible

19_044039 ch14.qxp 11/21/06 11:06 AM Page 265
Creating Formulas That Count and Sum
o make sure that the Analysis Toolpak add-in is installed, Click the Data tab. If the ribbon display the Data
TAnalysis command in the Analysisgroup, you’re all set. If not, you’ll need to install the add-in:
1. Choose Office ➪ Excel Options to display the Excel Options dialog box.
2. Click the Add-ins tab on the left.
3. Select Excel Add-Ins from the drop-down labeled Manage.
4. Click Go to display the Add-Ins dialog box.
5. Place a check mark next to Analysis ToolPak.
6. Click OK.
Note: In the Add-Ins dialog box, you see an additional add-in, Analysis ToolPak - VBA. This add-in is for pro-
grammer, and you don’t need to install it.
FIGURE 14.10 Is the Analysis Toolpak Installed? 14
Using data bars within a pivot table to display a histogram.

Summing Formulas

The examples in this section demonstrate how to perform common summing tasks by using formulas. The
formulas range from very simple to relatively complex array formulas that compute sums by using multiple
criteria.

Summing all cells in a range
It doesn’t get much simpler than this. The following formula returns the sum of all values in a range named
Data:
=SUM(Data)

265