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:
Search JabSto ::




Custom Search