Sum values with matching criteria across multiple sheets

[LenG.HTX]

Struggling with this one:

Sheet 1 has duplicate IDs with distinct values for each, for example:

Column K:K = duplicate ID#s > column T:T contains unique weight values for each line.

On sheet 2, I want to be able to enter the ID# and sum all of the weight values associated with that ID. I've attempted multiple SUM & SUMIFS, but I keep getting a #SPILL error.

Sheet 1 K:K
2081 Item 1 = 112 lbs
2081 Item 2 = 95 lbs
2081 Item 3 = 2 lbs

Sheet 2 operator enters 2081 in A:A, and C:C should return the sum of the weights, which should be 209.

I hope this makes sense.

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

[Limor_OP]

SPILL is usually not an error , it means the answer includes several values , and that the range needs to display the answer is not empty and that the results cant be displayed.
what if you wrap your formula with another SUM? does it give you an answer?