# Aggregation - Year to date

#### Libra0099

##### Active Member
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...

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
BCDEFGHIJKLMN
5*Mar-11YTD**********
6Bananas* * * * * 76,401,160***********
7*** 203,913,716**********
8*************
9*Jan-11Feb-11Mar-11Apr-11May-11Jun-11Jul-11Aug-11Sep-11Oct-11Nov-11Dec-11
10*************
11Apple* * * * * * *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
12Orange* * * * * * *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
13Bananas* * * * * 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

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### Haseeb Avarakkan

##### Well-known Member
Hello, Try

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

#### Libra0099

##### Active Member
Amazing.........

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

Really appreciate your help. Thanks a lot

Replies
0
Views
182
Replies
3
Views
251
Replies
4
Views
169
Replies
3
Views
351
Replies
9
Views
447

1,191,377
Messages
5,986,277
Members
440,016
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back