Adding new columns and keeping the old formulas

[HeRoseInThree]

If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula?

Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2)
But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)

Is there a way to make the current formula(s) add the new columns into their equation?

 

[jasonb75]

As long as you're only inserting columns, try

=COUNTIF(INDEX($2:$2,1,1):C$30,L2)

If you want to be able to insert rows as well then you would need to use INDIRECT (best avoided if possible) instead of INDEX.

 

[HeRoseInThree]

Thank you SO much!!!!