This may be hard to explain, but here goes nothing.
I have a spreadsheet with several tabs that link to each other. On the main sheet I am trying to make it such that when I drag the template cells down, they only count up by 1 for a certain formula that is linked to another sheet, but increase by 9 for the rest of the formulas.
For example:
In D15, I have =IF(A6="", "", A15-$H$2), then when I drag it, it becomes =IF(A15="", "", A24-$H$2).
But in D18, I have =IF(Observations!H5="","", Observations!H5) and when I drag that one, I only want it to increase by 1, but it always counts up by 9 becoming =IF(Observations!H14="","", Observations!H14).
I understand that it's counting up by that many because of the number of cells I am dragging it, but is there a way to increase all the other formulas by 9 and have this one formula only increase by 1?
Bookmarks