Excel 2007 : Excel 2007 Data Sorting / Formula Help

Hello,

I have a spreadsheet of data of approx 30 rows (wells) by 200 colums (days). Each row represents a producing oil / gas well and the data is in chronological order. Below is simplified example of the data I am working with (I've also included an attachment which is clearer due to the thread automatic formatting). Each numerical value (0,12,8 in the below example) represents a production amount. The first number greater than zero in the row represents the first day of production and the numbers following that represent subsequent production amounts. The wells have staggered first production dates due each well being drilled on different days (i.e. well 1 drilled on 1/2/11, well 2 drilled on 1/3/2011 so on and so forth). What I am trying to do is get the 30-day, 60-day and 90-day average production starting at the first day of production in the least labor intensive way. Is there any formula I can use that will find the first number greater than zero in the row and then return the 30-day, 60-day or 90-day average?

I tried using a find replace all to replace all the 0's with blanks and then selecting the data, hitting F5, then hitting special, then clicking blanks, then using the ctrl and - function to shift the cells left. This would then give me all the initial production dates for all of the wells in the second column, normalizing the first production date and making it easier for me to find the different averages I needed. This would work if after the first production date there was always a number greater than 0 or some production amount, but unfortunately there are days for which there is no production after the initial production date and by using the methodology I described above I would be overstating the averages due to all 0 production amounts being removed during the find replace all and then deletion of the blank cells.

Any suggestions at all would be much appreciated. Thank you in advance for your help.

-Sam


1/1/2011 1/2/2011 1/3/2011 1/4/2011 1/5/2011 1/6/2011 1/7/2011
Well 1 0 1 2 5 9 7 9
Well 2 0 0 6 8 0 0 10
Well 3 5 6 10 12 8 9 7
Well 4 0 0 0 0 9 10 8
Well 5 0 0 8 0 0 4 6