Avg Sum or RangeAvg

[danielnevitt]

Hi,

I have the below data:

Desk            Month 1         Month 2        Month 3        Month 4

A                    200                  250                  225                 275 

B                    300                  200                  100                200 

How do I calculate the average across each desk for the four month period?  Also how would I calculate it if I wanted to only use month 2, 3 and 4 for the average?

Thanks,

Daniel

[Taoufiq_Zarra · Accepted solution]

If I understood correctly

RangeAvg(Month1,Month2,...) as _RangAvg,