Lookup/Sumifs type formula struggle, should be simple

ryansapp

Board Regular
Joined
Apr 22, 2013
Messages
54
SUMIFS difficulty...need help with a lookup type formula, probably not even a SUMIFS? Finding or matching Lease Number, Period, and title of E1:J1, I want to output whats in my next tab appropriately. Unfortunately that next tabs data dump does not have the dates in the same format, hence they run E1:P1. Struggling and I'm sure its a super simple fix.

Excel 2016 (Mac) 32 bit
ADEFGHIJ

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Lease Number[/TD]
[TD="align: center"]Period[/TD]
[TD="align: center"] Gas Sales (MCF)[/TD]
[TD="align: center"] Gas Revenue[/TD]
[TD="align: center"] Oil Sales (Bbls)[/TD]
[TD="align: center"] Oil Revenue[/TD]
[TD="align: center"] $/mcf[/TD]
[TD="align: center"] $/bbl[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]12/1/15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]1/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]2/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]3/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]4/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]5/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]6/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]7/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 57[/TD]
[TD="align: right"] 2,550[/TD]

[TD="align: right"] $ 44.74[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]8/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]9/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]10/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]100200[/TD]
[TD="align: right"]11/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]12/1/15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]1/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]2/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]3/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]4/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]5/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]6/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]7/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]8/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]100300[/TD]
[TD="align: right"]9/1/16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 56[/TD]
[TD="align: right"] 2,410[/TD]

[TD="align: right"] $ 42.72[/TD]

</tbody>
Summary Operated


Excel 2016 (Mac) 32 bit
ACDEFGHIJKLMNOP
NumberCategoryPRODUCTION MONTH BASIS
BBLS SOLD
Oil Sales (Bbls) OIL BBLS - NET W.I.
OIL BBLS - NET O.R.R
TOTAL BARRELS SOLD
BBL DAILY AVERAGE
OIL EQB TOTAL
OIL EQB DAILY AVERAGE
WELL INCOME
MCF DAILY AVERAGE
LIQ DAILY AVERAGE
Oil Revenue OIL INCOME - W. I.
Unit Price
Oil Revenue OIL INCOME - O.R.R.I

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]12/1/15[/TD]
[TD="align: right"]1/1/16[/TD]
[TD="align: right"]2/1/16[/TD]
[TD="align: right"]3/1/16[/TD]
[TD="align: right"]4/1/16[/TD]
[TD="align: right"]5/1/16[/TD]
[TD="align: right"]6/1/16[/TD]
[TD="align: right"]7/1/16[/TD]
[TD="align: right"]8/1/16[/TD]
[TD="align: right"]9/1/16[/TD]
[TD="align: right"]10/1/16[/TD]
[TD="align: right"]11/1/16[/TD]

[TD="align: center"]46[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]47[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]57.48[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]48[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.22[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]49[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]59.7[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]50[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.99[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]51[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]59.7[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]52[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.99[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]53[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]54[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]55[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]56[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2231.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]57[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]38.82[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]58[/TD]
[TD="align: right"]100200[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]86.29[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

</tbody>
NBI Net Production Month Op
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
What you can do for a 2D SUMIF is actually a SUM with nested IFs using arrays. Note you'll need to press CONTROL+SHIFT+ENTER for this to work... You should see curly brackets around your formula if done correctly {=...}

I've also specifically locked down columns or rows with $ depending on which way the data and headings travel.
​[TABLE="class: grid, width: 1291"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Lease Number[/TD]
[TD]Period[/TD]
[TD]Gas Sales (MCF)[/TD]
[TD]Gas Revenue[/TD]
[TD]Oil Sales (Bbls)[/TD]
[TD]Oil Revenue[/TD]
[TD]$/mcf[/TD]
[TD]$/bbl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]100200[/TD]
[TD]12/01/2015[/TD]
[TD]=SUM(IF($D$26:$O$26=$B2,IF($B$27:$B$39=C$1,IF($A$27:$A$39=$A2,$D$27:$O$39))))[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100200[/TD]
[TD]1/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]100200[/TD]
[TD]2/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]100200[/TD]
[TD]3/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]100200[/TD]
[TD]4/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]100200[/TD]
[TD]5/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]100200[/TD]
[TD]6/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]100200[/TD]
[TD]7/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]57.48[/TD]
[TD]2317.39[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]100200[/TD]
[TD]8/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]100200[/TD]
[TD]9/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]100200[/TD]
[TD]10/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]100200[/TD]
[TD]11/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]100300[/TD]
[TD]12/01/2015[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]100300[/TD]
[TD]1/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]100300[/TD]
[TD]2/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]100300[/TD]
[TD]3/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]100300[/TD]
[TD]4/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]100300[/TD]
[TD]5/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]100300[/TD]
[TD]6/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]100300[/TD]
[TD]7/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]100300[/TD]
[TD]8/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]100300[/TD]
[TD]9/01/2016[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]Number[/TD]
[TD]Category[/TD]
[TD]PRODUCTION MONTH BASIS[/TD]
[TD]12/01/2015[/TD]
[TD]1/01/2016[/TD]
[TD]2/01/2016[/TD]
[TD]3/01/2016[/TD]
[TD]4/01/2016[/TD]
[TD]5/01/2016[/TD]
[TD]6/01/2016[/TD]
[TD]7/01/2016[/TD]
[TD]8/01/2016[/TD]
[TD]9/01/2016[/TD]
[TD]10/01/2016[/TD]
[TD]11/01/2016[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]BBLS SOLD[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]100200[/TD]
[TD]Oil Sales (Bbls)[/TD]
[TD]OIL BBLS - NET W.I.[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]57.48[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]OIL BBLS - NET O.R.R[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2.22[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]TOTAL BARRELS SOLD[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]59.7[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]BBL DAILY AVERAGE[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1.99[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]OIL EQB TOTAL[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]59.7[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]OIL EQB DAILY AVERAGE[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1.99[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]WELL INCOME[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]MCF DAILY AVERAGE[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]LIQ DAILY AVERAGE[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]100200[/TD]
[TD]Oil Revenue[/TD]
[TD]OIL INCOME - W. I.[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2231.1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]100200[/TD]
[TD][/TD]
[TD]Unit Price[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]38.82[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]100200[/TD]
[TD]Oil Revenue[/TD]
[TD]OIL INCOME - O.R.R.I[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]86.29[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top