Unable to lock a table column reference in a formula

I know I must be overlooking the obvious...

I have a formula using sumifs functions on a table and am trying to use $$ to lock in the table column so that as I drag the formula to other row cells the reference columns stay the same.

How are table columns locked in formulas?

SUMIFS(Table2[Qty],Table2[Rate Key],Capacity!$A27,Table2[Production
Week ],RIGHT(B$1,4)&" "&Capacity!B$2)

Found a work around.

Just needed to copy the cell and paste instead of dragging the cell.

Curious whether table columns can be locked in a formula though.