Forum Discussion
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
RSBNY199 Dragging across, meaning left to right. Correct? Then, it doesn't matter if the row number is relative (without the $) or absolute (with the $). A relative row number will, however, increment when you drag the formula down.
