Average Requirement

[Anonymous]

I have calculated the data as above, but I require average in 3 Months column of all other columns,

The green one is required result .

Please anyone help

[its_anandrjs]

Did you try Avg function with

=AVG(Expression of Aug-14 + Expression of Jul-14 + Expression of Jun-14)

[Anonymous]

Actually the expression is same,

Similarly I am having 12 Months and 6 Months column also available.....

fabs(sum(Data)-Sum(Forecast_Data_30))/sum(Data)

fabs(sum(Data)-Sum(Forecast_Data_60))/sum(Data)

fabs(sum(Data)-Sum(Forecast_Data_90))/sum(Data)

fabs(sum(Data)-Sum(Forecast_Data_120))/sum(Data)