The sum of multiple returns on a vlookup
Alibo wrote:
I am trying to get the sum of multiple returns on a VLOOKUP. As an example:
Jan 24
Jan 57
Jan 239
Feb 72
Mar 16
Mar 44
I want to get a result that looks like:
Jan Feb Mar
320 72 60
I have tried:
=SUMPRODUCT(VLOOKUP((Jan,A2:B7,2,FALSE))
But unfortunatley that just returns 24.
I hope someone can help.
Hi Alibo,
VLOOKUP is best to return a result from only the first row where the
criteria fit, hence your result.
For summary data, lay out "Jan Feb Mar" in D1:F1. In D2 put
=SUMIF($A2:$A7,D2,$B2:$B7)
and fill right.
Then there's the pivot table option...
|