Page 294 - Excel 2007 Bible

19_044039 ch14.qxp 11/21/06 11:06 AM Page 251
Getting a Quick Count or Sum
xcel’s status bar can display useful information about the currently selected cells — no formulas required.
ENormally, the status bar displays the sum and count of the values in the selected range. You can, however,
right-click to bring up a menu with other options. You can choose any or all of the following: Average, Count,
Numerical Count, Minimum, Maximum, and Sum.
Basic Counting Formulas Creating Formulas That Count and Sum 14
The basic counting formulas presented here are all straightforward and relatively simple. They demonstrate
the capability of the Excel counting functions to count the number of cells in a range that meet specific cri-
teria. Figure 14.1 shows a worksheet that uses formulas (in column E) to summarize the contents of range
A1:B10 — a 20-cell range named Data. This range contains a variety of information, including values, text,
logical values, errors, and empty cells.
FIGURE 14.1
Formulas in column E display various counts of the data in A1:B10.

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

251