Hello, I am trying to figure out how to write my formula with Rows function to add 12 rows to the formula when dragging down.
e.g. =INDIRECT("Gantt!$B$12") I need to change to INDIRECT("Gantt!$B$24") next B36, B48 etc..
I understand this should work =Rows(A$4:A12)*$C$1 with my incremental difference of 12 being in C1.
But I don't understand how to combine the two formulas.
thanks
Bookmarks