Microsoft Office Tutorials and References

In Depth Information

**AVERAGE**

=SUM(number 1, number 2, ...)

You can also use SUM with a range, as shown here:

=SUM(A1:A12)

You can also use SUM with more than one range, such as this:

=SUM(A1:A12, B1:B12)

AVERAGE

Although technically a statistical function, AVERAGE is used so often it

deserves a place in the top ten functions. Everyone is interested in averages.

What’s the average score? What’s the average salary? What’s the average

height? What’s the average number of hours we watch TV? (That’s a sore

spot in my home!)

AVERAGE can take up to 255 arguments. Each argument can be a number or a

range that contains numbers. The syntax follows:

=AVERAGE(number 1 ,number 2 ,...)

You can also use AVERAGE with a range, as shown here:

=AVERAGE(A1:A12)

You can also use AVERAGE with more than one range, such as this:

=AVERAGE(A1:A12, B1:B12)

COUNT

COUNT counts the number of cells in a range that contain numbers. It does

not provide any sum — just the count. For a list with ten numbers, for

example, COUNT returns 10, regardless of what the numbers are.

COUNT takes up to 255 arguments, which can be cell references, range

references, or numbers themselves. COUNT ignores non-numeric values. If an

argument to COUNT is A1:A10 but only two cells contain a number, then

COUNT returns 2. The syntax follows: