Combining production data

**areed145** · 09-02-2009, 04:22 PM

I have a data set of monthly oil production data from many wells in a field from different date ranges. I need to combine the different parameters from each well somehow to create field totals for every month. Is this possible short of adding them all up manually? I have attached the spreadsheet for reference. Each well has its own sheet. The result would look just like one of the sheets, but with totals from all the wells. This is a project for class and I cannot figure out how to accomplish this. Thanks in advance.

**contaminated** · 09-02-2009, 06:19 PM

Didn't entirely understand u, but I made totals list ... totals in my conception..

The totals summed up by wells, not by months.
For example, let's imagine thst i summed up by month... but for which year? As I understand 19940601 means 1st June Of 1994. But u have a lot of years stating from 1959. Submitting a table with months along with years + wells... it must be VERY!!! big table...

Hope u understand what I wanna say you..

Plzzz see attachment....

**areed145** · 09-02-2009, 07:03 PM

Thanks so much for working at this. This table will be useful later in the assignment (How did you make it?), but what I am trying to figure out right now is how to make something that would set up like attached with all the other parameters to the right of production days and following the same idea...the 19550501 means May 1, 1955. Each date entry is for the first of the month.

Thanks again!