You can use function offset.
See excel help for better uderstanding
Fill this to A1 and drag down.
=OFFSET(A1;0;2)+OFFSET(A1;0;4)+OFFSET(A1;0;6)-OFFSET(A1;0;3)-OFFSET(A1;0;5)-OFFSET(A1;0;7)Update
Sorry, I have non-English version of the Excel where ; are as separation character in formulas.
In English Excel is it probably with ,
=OFFSET(A1,0,2)+OFFSET(A1,0,4)+OFFSET(A1,0,6)-OFFSET(A1,0,3)-OFFSET(A1,0,5)-OFFSET(A1,0,7) Greetings! I look forward to getting to know you all more on this board!
It already looks like there's a ton of great answers! Here's mine:
I was wondering if there is a way to insert rows or columns without messing up my formulas. Obviously the formulas I have all rely upon Column locations.. For instance I have a number of formulas working with column "E" ... But I need to add a column before E; is there any way to do that and have all the formulas automatically update?
Thanks!
Square and cube roots
Click here to reveal answer
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).