SOLVED

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

Brass Contributor

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])

 

 

3 Replies
best response confirmed by rodsan724 (Brass Contributor)
Solution

@rodsan724 

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

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

Accepted Solutions
best response confirmed by rodsan724 (Brass Contributor)
Solution

@rodsan724 

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

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

View solution in original post