sumif only seeing one row

Tried to find an answer but haven't found one yet.

I have two sheets. On Sheet 1, I have a Demo Code (1, 2, 3, etc.) in A9:A17
and a total quantity column in column W. This is where my sumif would go.

On Sheet 2, I have the Demo Code going across from D5:L5. Below that, I have
quantities listed for each demo code going to different people. The columns
are then totaled below in row 113. I want to show the quantity for each demo
code in the Total Quantity column on Sheet 1.

In my total quantity column on Sheet 1, I have the following formula:
=SUMIF('Sheet 2'!$D$5:$L$5,'Sheet 1'!$A9,'Sheet 2'!$D$6:$L$113).

So for some reason, it's only returning the first row (D6) and not the
entire column. The column does have spaces as each address is separated by a
row or two, but since the range is listed, I don't know why that would be a
problem. Any ideas? Thanks!