Sum if vlookup index match

[Pripri]

I’m trying to accomplish the following: (my formula will bebased on a specific month, year, program name and look at a program descriptionto give me the year to date total.) I will have several lines with the same
year, same program and same program description looking for the Year to date total for "February"

Please use this first table:

Year to date
2018	New Jersey	Pink
	February	12
			Period 1	Period 2	Period 3		January	February	March
2018	New Jersey	Pink	5	5	5		5	10	15
2018	New Jersey	Pink	1	1	1		1	2	3
2019	Virginia	Yellow	10	5	5		10	15	20
2017	Virginia	Blue	5	2	2		5	7	9
2018	Virginia	Yellow	1	1	1		1	2	3
2019	Virginia	Yellow	2	2	2		2	4	6

<colgroup><col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;"> <col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4864;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="64" style="width: 48pt;" span="4"> <tbody> </tbody>

Year to date
2018	New Jersey	Pink
	February	12
			Period 1	Period 2	Period 3		January	February	March
2018	New Jersey	Pink	5	5	5		5	10	15
2018	New Jersey	Pink	1	1	1		6	2	3
2019	Virginia	Yellow	10	5	5		7	15	20
2017	Virginia	Blue	5	2	2		8	7	9
2018	Virginia	Yellow	1	1	1		9	2	3
2019	Virginia	Yellow	2	2	2		10	4	6

<tbody>
</tbody>

Year to date
2018	New Jersey	Pink
	February	12
			January	February	March
2018	New Jersey	Pink	5	5	5
2018	New Jersey	Pink	1	1	1
2019	Virginia	Yellow	10	5	5
2017	Virginia	Blue	5	2	2
2018	Virginia	Yellow	1	1	1
2019	Virginia	Yellow	2	2	2

<tbody>
</tbody>

 

[Fluff]

In what way is this different from this thread https://www.mrexcel.com/forum/excel...h-sum-if-vlookup-post5328896.html#post5328896