Aggregation - Year to date

[Libra0099]

Dear all,

Good day!

It may be very simple but I am stuck. I also searched the forum for the word aggregation but could not get relveent... it may be due to I am stuck...

Can you please help me with this....

Currently I am using two way lookup to pick month wise information. I need a formula which should return the aggregation. For example

In below data…. For Bananas & for moth of march I have 76,401,160. In next cell I need the aggregation of Jan to Mar and that is 203,913,716. This formula should be flexible that mean if I change the criteria in cell B6 or C5 it should return the desired result.

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N
5	*	Mar-11	YTD	*	*	*	*	*	*	*	*	*	*
6	Bananas	* * * * * 76,401,160	*	*	*	*	*	*	*	*	*	*	*
7	*	*	* 203,913,716	*	*	*	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*	*	*	*	*	*	*
9	*	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11
10	*	*	*	*	*	*	*	*	*	*	*	*	*
11	Apple	* * * * * * *3,040,130	* * * 2,446,350	* * * 2,481,077	* * * 2,509,115	* * * * * 1,847,749	* * * 2,350,092	* * * * * 922,294	* * * 2,237,296	* * * 2,532,020	* * * 2,466,220	* * * 1,883,121	* * * 2,002,419
12	Orange	* * * * * * *8,255,262	* * * 6,746,898	* * 14,599,372	* * 19,177,184	* * * * * 8,940,533	* * 12,021,194	* * * 5,454,538	* * * 2,822,313	* * * 9,369,030	* * 12,105,896	* * 26,425,127	* * 34,064,465
13	Bananas	* * * * * 65,292,213	* * 62,220,342	* * 76,401,160	* * 78,520,289	* * * * 73,100,942	* * 66,866,253	* * 63,789,715	* * 54,237,533	* * 64,655,984	* * 62,830,726	* * 67,440,504	* * 60,254,939
Sheet1

 

[Haseeb Avarakkan]

Hello, Try

=SUM(INDEX(C11:N13,MATCH(B6,B11:B13,0),1):INDEX(C11:N13,MATCH(B6,B11:B13,0),MONTH(C5)))

 

[Libra0099]

Amazing.........

I was just near to this but my mind was stopped to think any more... hahahaha


Really appreciate your help. Thanks a lot