I want to refer to the row number of a column based on a formula. Is there a way to refer to a cell where the row number changes using a formula, even though I'm using the A1 style of referencing? Or would I have to change to R1C1 style?
For instance, within a formula, I need to refer to a cell in column F, but the cell I need to refer to changes based on a counta() fn. For instance, the formula might be something like =SUM(Fx:F25) where x= counta(C1:C10).
I'm just blanking out on this, and I'm sure the answer is probably simple. Thanks for your help.