Excel 2010 Bible

Chapter 13: Creating Formulas That Count and Sum

299

Cross-Reference
I cover pivot tables in detail in Chapters 34 and 35, and you can learn more about the conditional formatting
data bars in Chapter 20. n

FIGURE 13.10

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 for-

mulas. 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)

The SUM function can take up to 255 arguments. The following formula, for example, returns the

sum of the values in five noncontiguous ranges:

=SUM(A1:A9,C1:C9,E1:E9,G1:G9,I1:I9)