Sumifs for Data given with multiple columns

[Surbhi_baphna]

Hi ,

I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria.

For ex :

In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June as well. Pls help, waiting for answer...

	YTD	YTD	YTD	YTD	YTD	YTD	0	0	0
	Bus A	Bus A	Bus B	Bus A	Bus A	Bus B	Bus A	Bus A	Bus B
	Level 1	Level 2	Level 1	Level 1	Level 2	Level 1	Level 1	Level 2	Level 1
	Apr	Apr	Apr	May	May	May	June	June	June
Sample 1	2	3	4	5	6	7	8	9	10
Sample 2	3	4	5	6	7	8	9	10	11
Sample 3	4	5	6	7	8	9	10	11	12

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[steve the fish]

Hi. Something like:

=SUMIFS(INDEX($B$5:$J$7,MATCH("Sample 2",$A$5:$A$7,0),0),$B$1:$J$1,"YTD",$B$2:$J$2,"Bus A",$B$3:$J$3,"Level 1")

 

[Surbhi_baphna]

Thanks a lot, this works well