Use AVERAGE with more than one range: =AVERAGE(A1:A12, B1:B12) : AVERAGE « Statistical functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. AVERAGE

Input the formula: =AVERAGE(A1:A12, B1:B12)

21.1.AVERAGE
	21.1.1.	AVEDEV(number1,number2,...) returns the average of the absolute deviations of data points from their mean
	21.1.2.	AVERAGE(number1,number2,...) returns the average (arithmetic mean)
	21.1.3.	=AVERAGE(B2:B6, 5) returns the average of the numbers and 5
	21.1.4.	Use AVERAGE with more than one range: =AVERAGE(A1:A12, B1:B12)