New Contributor

# How to Get unlocked Row of Reference Cell to Change

Hello,

I have a workbook where I have a multi conditional SUMIFS formula where the only changing references are two row numbers from another sheet. when I try to drag copy the formula across my table, the unlocked rows in the cell references won't change.

Does anyone know how I can get this formula to copy across the columns with the unlocked row changing sequentially?

This is the formula

=SUM(SUMIFS(Invoices!\$F\$3:\$F\$151,Invoices!\$A\$3:\$A\$151,'Reference Sheet'!\$F\$6,Invoices!\$B\$3:\$B\$151,"Contract",Invoices!\$E\$3:\$E\$151,">="&'Reference Sheet'!\$B4,Invoices!\$E\$3:\$E\$151,"<="&'Reference Sheet'!\$C4))

Thank You,

Rich