<div>
Perfect. &nbsp;I had used the INDEX &quot;array form&quot;, but not the &quot;reference form.&quot; &nbsp;I had forgotten about the reference form. &nbsp;Thanks for the help.
</div>


Perfect.  I had used the INDEX "array form", but not the "reference form."  I had forgotten about the reference form.  Thanks for the help.

<div>
<div class="content wysiwyg-content">
I want to refer to the row number of a column based on a formula. &nbsp;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? &nbsp;Or would I have to change to R1C1 style? &nbsp;<br />
<br />
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. &nbsp;For instance, the formula might be something like =SUM(Fx:F25) where x= counta(C1:C10). &nbsp;<br />
<br />
I'm just blanking out on this, and I'm sure the answer is probably simple. &nbsp;Thanks for your help.
</div>
</div>


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.

change column number in A1 reference based on formula.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.