Forum Discussion
Solved
How to maintain a fixed range when cell is added
=SUM(J10:J58+G10:G58) The above formula works perfectly fine However, each week an additional cell needs to be inserted in J10:J58 This causes the formula to return an error For...
You can use the INDIRECT function for this purpose:
=SUM(INDIRECT("J10:J58"), G10:G58)
If you also want to keep G10:G58 fixed:
=SUM(INDIRECT("J10:J58"), INDIRECT("G10:G58"))
You can use the INDIRECT function for this purpose:
=SUM(INDIRECT("J10:J58"), G10:G58)
If you also want to keep G10:G58 fixed:
=SUM(INDIRECT("J10:J58"), INDIRECT("G10:G58"))