Vlookup and sum help

[Gohar Shahab]

I am using this formula to match values but at the same time i want to sum all the values matched in the formula..

=VLOOKUP(A11,$A$1:$D$7,MATCH($B$9,$A$1:$D$1,0),0)

The above formula picks up first value but there are other values for same matched value that i want to add with this.

please assist..

Code 31/01/2011 28/02/2011 31/03/2011
Micl 1
Pirt 2
Micl 1
Pirt 2
Micl 1
Pirt 2

I want to add all matching values for "Micl"
31/01/2011
Micl 1 =VLOOKUP(A11,$A$1:$D$7,MATCH($B$9,$A$1:$D$1,0),0)
Pirt 2

 

[truskawa]

Hi, unfortunatelly vlookup picks only first value. I don't know how complicated your problem is but what I would try would be:
1. Pivot table
2. SUMIF function
3. writing own fuction in VBA if above do not help

 

[Gohar Shahab]

Hi, unfortunatelly vlookup picks only first value. I don't know how complicated your problem is but what I would try would be:
1. Pivot table
2. SUMIF function
3. writing own fuction in VBA if above do not help

Yes, it picks up but i have reports which work on date value on the column and sum of all the values matching criteria..

any other solution.
thanks