0

I'm having a report where I add a set of columns programmatically every months.

The issue is the formulas adapt cell reference to the old set of columns and not the one I want to see.

For instance in my example sheet, I want the formula to be A3-C3 and remain like this even if I add a column in between A and C. But when the February column is being added, formula becomes A3-E3. How can I keep the same cells reference even if I add something in between?

I know this formula works =INDIRECT("A3")-INDIRECT("C3") But I have hundreds of rows and this kind of formulas cannot be extended If I'm not mistaken.

Thanks in advance for your help.

Damien
  • 143
  • 1
  • 10
  • 1
    You don't have to extend. Use a array instead: `=ARRAYFORMULA(INDIRECT("A3:A")-INDIRECT("C3:C"))`. Another alternative is `INDEX` in my previous answer – TheMaster Oct 20 '22 at 06:51

0 Answers0