Hi,

You really should use SUMIF but here is the correct SUMPRODUCT formula

=SUMPRODUCT(($A2:$A14=D1)*$B2:$B14)

Where Jan is in D1 and you want to copy from left to right.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.

Alibo