I am looking for a formula that will compute a rolling average of the raw tons produced for the most recent 30 shifts worked. In the attached spreadsheet, I am looking for a formula for cell H71 which will do the following: beginning with the most recent data entered, add column G until we reach "greater than or equal to 30 AND less than 31". (In the attached example that would be Cell G22). Then provide an average for the values in Column H which are associated with the most recent 30-31 shifts. (In the attached the answer would be 1434/30.5 which equals 47.02.

I will be entering new data each day and this number will "roll".

Thank you for any assistance to my ignorance! Much obliged!



(Unfortunately something is prohibiting me from attaching the file - any thoughts?)