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 ...
In D2:
=SUM(OFFSET(D2,0,-3,1,3))or
=SUM(INDEX(2:2,COLUMN()-3):INDEX(2:2,COLUMN()-1))Fill down.
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
In which cell do you want the formula? In A4?
