Hello,
I have a template with formulas that I frequently copy into new sheets, but I don't know how to write the formulas so that they update to reflect a new range once copied.
Example of template formula:
=SUMIFS(L4:L6,A4:A6,"*cost*",Q4:Q6,"main")
Example of desired update once copied:
=SUMIFS(L2:L627,A2:A627,"*cost*",Q2:Q627,"main")
The columns don't ever change, but the total row count does (row 1 is always headers). Is there a way to write the formulas so that pasting the template formula will update the range from 4:6 to 2:the last row with data? Some sort of CellUp function perhaps?
Bookmarks