Excel When I insert a column I don't want cell references in forumula to follow

Brass Contributor


I have 2 tables in Excel. Table1 (column1, column2) and Table2 (column3, column4).

In column2 I have a forumula like the following:




If I insert a column in front of Column3 the formula in column2 stays with column3


how do I make it stay on the new column?





3 Replies
best response confirmed by rodsan724 (Brass Contributor)


If you'd like to keep reference on the first column in Table2 that could be like

=COUNTA(INDEX( Table2,0,1) )