Sumif Index match match

[Zdesgain11]

I currently have a set of data as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan-18[/TD]
[TD]Feb-18[/TD]
[TD]Mar-18[/TD]
[TD]Apr-18[/TD]
[TD]Jun-18[/TD]
[TD]Jul-18[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]13
[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[/TR]
</tbody>[/TABLE]

I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal to the month I choose.

For example, If I am looking at A, and want to choose April, I would want to sum April, March, Feb and Jan for a total of 4+3+2+1 = 10.

Does anyone know how to make this possible? I thought about a Sumif Index Match Match formula, but im not sure the best way to set it up.

 

[DanteAmor]

Try this:

Excel Workbook
	A	B	C	D	E	F	G	H
1	jan-18	feb-18	mar-18	apr-18	may-18	jun-18		Sum Apr
2	1	2	3	4	5	6		10
3	7	8	9	10	11	12
4	13	14	15	16	17	18
5	19	20	21	22	23	24
Hoja3

 

[Aladin Akyurek]

Book1
	A	B	C	D	E	F	G	H	I	J
1		1/1/2018	2/1/2018	3/1/2018	4/1/2018	6/1/2018	7/1/2018			A
2	A	1	2	3	4	5	6			4/1/2018
3	B	7	8	9	10	11	12			10
4	C	13	14	15	16	17	18
5	D	19	20	21	22	23	24
Sheet1

In J3 enter:

=SUMIFS(INDEX($B$2:$G$5,MATCH(J1,$A$2:$A$5,0),0),$B$1:$G$1,"<="&J2)

 

[Zdesgain11]

Thank you! That does work - I am trying to take it to the next level though, for example:

I have multiple "customers" on my other tab in separate columns as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Customer 1[/TD]
[TD]Customer 2[/TD]
[TD]Customer 3[/TD]
[TD]Customer 4[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

my data set has data mentioned below for each customer as follows:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan 2018[/TD]
[TD]Feb 2018[/TD]
[TD]Mar 2018[/TD]
[TD]Apr 2018[/TD]
[TD]May 2018[/TD]
[TD]Jun 2018[/TD]
[/TR]
[TR]
[TD]Customer 1-A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 1-B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 1-C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 1-D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer 2-A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 2-B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 2-C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer 2-D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is there anyway to match the customer on the first tab to the product and then sum the values less than or equal to the date?

 

[Zdesgain11]

THIS IS EXACTLY WHAT I NEEDED! Thank you so much