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?
@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.