Index Match and Sums

[DeepikaB]

Hello I am so glad to find this forum, might question might be super easy for most of you but I am beating my head on a wall from last few hours so thought to register and raise it here

I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16 from a Drop down say then it gives me sum of 6 and it updates automatically based on the month I select. Index match match or sum index I am not able to get the answer please please help !! I am not able to paste an Image hopefully will learn soon.

Thanks,
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Jan 16
[/TD]
[TD]Feb 16[/TD]
[TD]Mar 16[/TD]
[TD]Apr 16[/TD]
[TD]Month Total[/TD]
[TD]Year To Date Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DB[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1034"]
<colgroup><col span="14"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Hi and welcome to MrExcel,

Try something like this:

Book1
	A	B	C	D	E	F	G
1	select Month:	Mar 16
2
3	Name	jan-16	feb-16	Mar 16	apr-16	Month Total	Year To Date Total
4	DB	1	2	3	4	3	6
Sheet1

Cell Formulas
Range	Formula
F4	=INDEX(B4:E4,MATCH(B1,B3:E3,0))
G4	=SUM(OFFSET(B4,0,0,,MATCH(B1,B3:E3,0)))

 

[Fluff]

Another option, without volatile functions

Book1
	A	B	C	D	E	F	G
1	select Month:	01-03-2016
2
3	Name	01-01-2016	01-02-2016	01-03-2016	01-04-2016	Month Total	Year To Date Total
4	DB	1	2	3	4	3	6
personal_info

Cell Formulas
Range	Formula
F4	=INDEX(B4:E4,MATCH(B1,B3:E3,0))
G4	=SUM(B4:INDEX(B4:E4,MATCH(B1,B3:E3,0)))