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

[rodsan724]

Hi,

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

In column2 I have a forumula like the following:

=COUNTA(Table2[Column3])

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?

=COUNTA(Table2[Column1])

[#2 · Accepted solution]

@rodsan724 

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

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

[#3]

Perfect!

[#4]

@rodsan724 , you are welcome