NEED HELP: Trying calculate a formula across a spreadsheet every 7th coulumn

[sharahoff]

I need help repeating a process that takes forever by hand. I want to first calculate a column (Cumm BOE) for each entryl on a spreadsheet.

1. Take BOE on row 5 and place the first sum in Cumm BOE column. (= BOE cell)
2. Calculate row 6 Cumm BOE by adding row 5 Cumm BOE to row 6 BOE for total. (Cumm BOE is just a running total of all oil & gas produced)
3. Select the cell with the new cumm BOE formula on on row 6 and copy it down the column to figure cumm BOE.
5. Select both columns (BOE & Cumm BOE) and formatt to 0 decimals.
6. Repeat this procedure on every 7th column (Cumm BOE) for the remainder of the worksheet.

Note: Many times I have 400-500 wells in a row, the example attached shows only 119. The rows will be determined by how many rusults have been reported, so the number of rows could be 3 or 1000... Depends on how long the well has been in production.

I am open to using any commands that shorten or simplify this process as long as I can get the document formatted properly and get the desired results.

Any guidence would be appreciated.

Thank You

[rylo]

Hi

Try this

Please Login or Register  to view this content.

rylo

[mike7952]

@sharaoff,

Just noticed this post and seen that its another step for the code I coded for you earlier today. I just added the formulas to the code.

Please Login or Register  to view this content.

[sharahoff]

Thank you Mike! Worked perfect!

Rylo, thank you for your post as well.

[mike7952]

Your welcome... "barrel of oil", I used to be a rough neck in the north east drilling gas wells.