Lookup/Sumifs type formula struggle, should be simple

[ryansapp]

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

	A	D	E	F	G	H	I	J
1	Lease Number	Period	Gas Sales (MCF)	Gas Revenue	Oil Sales (Bbls)	Oil Revenue	$/mcf	$/bbl
14	100200	12/1/15			-	-
15	100200	1/1/16			-	-
16	100200	2/1/16			-	-
17	100200	3/1/16			-	-
18	100200	4/1/16			-	-
19	100200	5/1/16			-	-
20	100200	6/1/16			-	-
21	100200	7/1/16			57	2,550		$ 44.74
22	100200	8/1/16			-	-
23	100200	9/1/16			-	-
24	100200	10/1/16			-	-
25	100200	11/1/16			-	-
26	100300	12/1/15			-	-
27	100300	1/1/16			-	-
28	100300	2/1/16			-	-
29	100300	3/1/16			-	-
30	100300	4/1/16			-	-
31	100300	5/1/16			-	-
32	100300	6/1/16			-	-
33	100300	7/1/16			-	-
34	100300	8/1/16			-	-
35	100300	9/1/16			56	2,410		$ 42.72

<tbody>
</tbody>

Summary Operated​

Excel 2016 (Mac) 32 bit

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Number	Category	PRODUCTION MONTH BASIS	12/1/15	1/1/16	2/1/16	3/1/16	4/1/16	5/1/16	6/1/16	7/1/16	8/1/16	9/1/16	10/1/16	11/1/16
46	100200		BBLS SOLD	0	0	0	0	0	0	0	0	0	0	0	0
47	100200	Oil Sales (Bbls)	OIL BBLS - NET W.I.	0	0	0	0	0	0	0	57.48	0	0	0	0
48	100200		OIL BBLS - NET O.R.R	0	0	0	0	0	0	0	2.22	0	0	0	0
49	100200		TOTAL BARRELS SOLD	0	0	0	0	0	0	0	59.7	0	0	0	0
50	100200		BBL DAILY AVERAGE	0	0	0	0	0	0	0	1.99	0	0	0	0
51	100200		OIL EQB TOTAL	0	0	0	0	0	0	0	59.7	0	0	0	0
52	100200		OIL EQB DAILY AVERAGE	0	0	0	0	0	0	0	1.99	0	0	0	0
53	100200		WELL INCOME	0	0	0	0	0	0	0	0	0	0	0	0
54	100200		MCF DAILY AVERAGE	0	0	0	0	0	0	0	0	0	0	0	0
55	100200		LIQ DAILY AVERAGE	0	0	0	0	0	0	0	0	0	0	0	0
56	100200	Oil Revenue	OIL INCOME - W. I.	0	0	0	0	0	0	0	2231.1	0	0	0	0
57	100200		Unit Price	0	0	0	0	0	0	0	38.82	0	0	0	0
58	100200	Oil Revenue	OIL INCOME - O.R.R.I	0	0	0	0	0	0	0	86.29	0	0	0	0

<tbody>
</tbody>

NBI Net Production Month Op​

 

[NiMip]

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.
​

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Lease Number	Period	Gas Sales (MCF)	Gas Revenue	Oil Sales (Bbls)	Oil Revenue	$/mcf	$/bbl
2	100200	12/01/2015	=SUM(IF($D$26:$O$26=$B2,IF($B$27:$B$39=C$1,IF($A$27:$A$39=$A2,$D$27:$O$39))))	0	0	0	0	0
3	100200	1/01/2016	0	0	0	0	0	0
4	100200	2/01/2016	0	0	0	0	0	0
5	100200	3/01/2016	0	0	0	0	0	0
6	100200	4/01/2016	0	0	0	0	0	0
7	100200	5/01/2016	0	0	0	0	0	0
8	100200	6/01/2016	0	0	0	0	0	0
9	100200	7/01/2016	0	0	57.48	2317.39	0	0
10	100200	8/01/2016	0	0	0	0	0	0
11	100200	9/01/2016	0	0	0	0	0	0
12	100200	10/01/2016	0	0	0	0	0	0
13	100200	11/01/2016	0	0	0	0	0	0
14	100300	12/01/2015	0	0	0	0	0	0
15	100300	1/01/2016	0	0	0	0	0	0
16	100300	2/01/2016	0	0	0	0	0	0
17	100300	3/01/2016	0	0	0	0	0	0
18	100300	4/01/2016	0	0	0	0	0	0
19	100300	5/01/2016	0	0	0	0	0	0
20	100300	6/01/2016	0	0	0	0	0	0
21	100300	7/01/2016	0	0	0	0	0	0
22	100300	8/01/2016	0	0	0	0	0	0
23	100300	9/01/2016	0	0	0	0	0	0
24
25
26	Number	Category	PRODUCTION MONTH BASIS	12/01/2015	1/01/2016	2/01/2016	3/01/2016	4/01/2016	5/01/2016	6/01/2016	7/01/2016	8/01/2016	9/01/2016	10/01/2016	11/01/2016
27	100200		BBLS SOLD	0	0	0	0	0	0	0	0	0	0	0	0
28	100200	Oil Sales (Bbls)	OIL BBLS - NET W.I.	0	0	0	0	0	0	0	57.48	0	0	0	0
29	100200		OIL BBLS - NET O.R.R	0	0	0	0	0	0	0	2.22	0	0	0	0
30	100200		TOTAL BARRELS SOLD	0	0	0	0	0	0	0	59.7	0	0	0	0
31	100200		BBL DAILY AVERAGE	0	0	0	0	0	0	0	1.99	0	0	0	0
32	100200		OIL EQB TOTAL	0	0	0	0	0	0	0	59.7	0	0	0	0
33	100200		OIL EQB DAILY AVERAGE	0	0	0	0	0	0	0	1.99	0	0	0	0
34	100200		WELL INCOME	0	0	0	0	0	0	0	0	0	0	0	0
35	100200		MCF DAILY AVERAGE	0	0	0	0	0	0	0	0	0	0	0	0
36	100200		LIQ DAILY AVERAGE	0	0	0	0	0	0	0	0	0	0	0	0
37	100200	Oil Revenue	OIL INCOME - W. I.	0	0	0	0	0	0	0	2231.1	0	0	0	0
38	100200		Unit Price	0	0	0	0	0	0	0	38.82	0	0	0	0
39	100200	Oil Revenue	OIL INCOME - O.R.R.I	0	0	0	0	0	0	0	86.29	0	0	0	0

<tbody>
</tbody>