Sep 29 2021 12:17 PM
I have numbers in columns a, b & c. In column d I have a formula that adds up the three numbers to the left. I need to be able to insert a blank column at column D, insert a new number into column D and have the formula automatically adjust to add the three numbers to the left which will now be columns b, c & d. Is there any way to do that?
Sep 29 2021 12:33 PM
SolutionIn D2:
=SUM(OFFSET(D2,0,-3,1,3))
or
=SUM(INDEX(2:2,COLUMN()-3):INDEX(2:2,COLUMN()-1))
Fill down.
Sep 29 2021 01:19 PM
Sep 29 2021 01:29 PM
Sep 29 2021 01:47 PM
I'm confused. You first mentioned A1-A2+A3, then A1-B1+C1 and finally something with B1 and C2.
Please explain.
Sep 29 2021 01:50 PM
Sep 29 2021 02:21 PM
Thanks. That would be
=INDEX(2:2,COLUMN()-3)-INDEX(2:2,COLUMN()-2)+INDEX(2:2,COLUMN()-1)
Sep 29 2021 02:49 PM
Sep 29 2021 12:33 PM
SolutionIn D2:
=SUM(OFFSET(D2,0,-3,1,3))
or
=SUM(INDEX(2:2,COLUMN()-3):INDEX(2:2,COLUMN()-1))
Fill down.