Hi,

I need to extract in sheet "Raport", based on reference and month, the average sales from the previous three months.

Sheet "Sales"
reference January 2013 February 2013 March 2013 April 2013 May 2013
123456 10 20 30 40 50
789101 60 70 80 90 100


Sheet "Raport"
Reference April 2013 May 2013
123456 20 30
789101 70 80

I need in sheet "Raport" to display for reference 123456 and April 2013, the average sales from the previous three months. (Sheet "Sales" : 10,20,30 = average "30")
For May to display 30, which is the average from February, March and April from sheet "Sales"....and so on.


Can this be done?

Thank you kindly.