Hi everyone, so I am witnessing some strange behaviour when trying to make a spreadsheet for work.
If you take a look at the file, you will see that on cell N4 I sum up the content of cells A4 to L4 until it adds up to less than the target value (M4). Moreover, on O4 I count the amount of cells that were added in the aforementioned operation.
The problem that I am encountering is that if I copy the whole table (range A2:O4) to another location wihin the spreadsheet, the two colored cells with the formulas that I mentioned earlier will only work sometimes.
For instance, I think that pasting the table on any row, but starting from column G onwards, the formulas stop working. Whatever is happening is way out of my league.
This will be a problem for me, as the spreadsheet that I am trying to create will require this formula to be used multiple times on many cells.
Please help
If you take a look at the file, you will see that on cell N4 I sum up the content of cells A4 to L4 until it adds up to less than the target value (M4). Moreover, on O4 I count the amount of cells that were added in the aforementioned operation.
The problem that I am encountering is that if I copy the whole table (range A2:O4) to another location wihin the spreadsheet, the two colored cells with the formulas that I mentioned earlier will only work sometimes.
For instance, I think that pasting the table on any row, but starting from column G onwards, the formulas stop working. Whatever is happening is way out of my league.
This will be a problem for me, as the spreadsheet that I am trying to create will require this formula to be used multiple times on many cells.
Please help