AVE

Formula AVERAGE is used to search the average value. Example of formula  is =AVERAGE(RANGE X:RANGE Y)

Example 1 : To find the average value of a row or column. 

In selected destination cell, type =AVERAGE(RANGE X:RANGE Y). In this example, the formula would be =AVERAGE(B2:B7).

Hit the enter button to get the average result.

Use the increase and decrease decimals to get the best value. Go to Home->Number-> Choose either to increase or decrease decimals

Example 2 : To find average value of multiple rows or columns.

In selected destination cell, type =AVERAGE(RANGE X:RANGE Y). In this example, the formula would be =AVERAGE(B2:C7).

Hit the enter button to get the average result.