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






Input the formula: =AVERAGE(A1:A12, B1:B12)
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 meanAVEDEV(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)AVERAGE(number1,number2,...) returns the average (arithmetic mean)
21.1.3.=AVERAGE(B2:B6, 5) returns the average of the numbers and 5=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)Use AVERAGE with more than one range: =AVERAGE(A1:A12, B1:B12)