Microsoft Office Tutorials and References

In Depth Information

**Calculating a Sum**

3

•
Click cell B5.

•
Enter the remaining ﬁ rst quarter

sales numbers provided in Table 1–1

for each of the four remaining

offerings in rows 5, 6, 7, and 8 to

display the quarterly sales in the

worksheet (Figure 1–31).

data entered

into worksheet

row title partially

displayed because

adjacent cell on

right contains data

Figure 1–31

The next step in creating the worksheet is to perform any necessary calculations, such as

calculating the column and row totals.

Plan

Ahead

Determine calculations that are needed.

As stated in the requirements document in Figure 1–2 on page EX 4, totals are required for

each region, each product type, and the company. The ﬁ rst calculation is to determine the

quarterly sales for the stores in the Northeast region in column B. To calculate this value

in cell B9, Excel must add, or sum, the numbers in cells B4, B5, B6, B7, and B8. Excel’s
SUM

function
, which adds all of the numbers in a range of cells, provides a convenient means to

accomplish this task.

A
range
is a series of two or more adjacent cells in a column or row or a rectangular

group of cells. For example, the group of adjacent cells B4, B5, B6, B7, and B8 is called a

range. Many Excel operations, such as summing numbers, take place on a range of cells.

After the total quarterly sales for the stores in the Northeast region in column B is

determined, the totals for the remaining regions and totals for each product type will be

determined.

Entering Numbers

as Text

Sometimes, you will want

Excel to treat numbers,

such as Zip codes and

telephone numbers, as

text. To enter a number

as text, start the entry

with an apostrophe (‘).

Calculating Sums

Excel calculates sums for a

variety of data types. For

example, Boolean values,

such as TRUE and FALSE,

can be summed. Excel

treats the value of TRUE

as 1 and the value of

FALSE as 0. Times also can

be summed. For example,

Excel treats the sum of

1:15 and 2:45 as 4:00.