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)