Forum Discussion
Solved
Excel
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?
In D2:
=SUM(OFFSET(D2,0,-3,1,3))or
=SUM(INDEX(2:2,COLUMN()-3):INDEX(2:2,COLUMN()-1))Fill down.
9 Replies
In D2:
=SUM(OFFSET(D2,0,-3,1,3))or
=SUM(INDEX(2:2,COLUMN()-3):INDEX(2:2,COLUMN()-1))Fill down.
It worked! Thank you thank you thank you!!!
- One follow-up question - how would I write the formula if I want to do A1-A2+A3
