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.
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?
- No, in cell D1. So D1 adds A1, subtracts, b1, then adds C1. We need to be able to insert a blank column at D and have the formula which now appears in E1 automatically adjusted to add B1, subtract C2 and Add the new entry in D1. We'll be doing this every month always analyzing the last three months.
I'm confused. You first mentioned A1-A2+A3, then A1-B1+C1 and finally something with B1 and C2.
Please explain.