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 t...
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.