Hi.

I think you need to use a sum if function instead of vlookup. The latter only returns the first value.

Also, It looks like you forgot to "lock" the formula so you might get the wrong result for the next rows.

When you use A2:J31011 and copy down the formula, the next row will have formula A3:J31012

I suggest using A:J instead. The function will search all rows. I

Best regards Tbez