Conquer Club, a free online multiplayer variation of a popular world domination board game.
https://conquerclub.com/forum/
ummmm , use the vlookup function ??spinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
i am not sure cuz i didnt understand u correctly!yes or thatwcaclimbing wrote:copy paste?
Ctrl C to copy the cellspinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
Would it be possible to rearrange the cells containing the data (the ones your formula points to), so that you can copy & paste without having to change anything. For example, transposing rows for columns, or something?spinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
no, this is my formula-Gen Monty wrote:Ctrl C to copy the cellspinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
Crtl V to paste the cell
Code: Select all
=B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43+B44+B46+B45+B47+B48+B49+B50+B51+B52+B53Code: Select all
=B56+B57+B58.....would it work 4 my example?Stopper wrote:Would it be possible to rearrange the cells containing the data (the ones your formula points to), so that you can copy & paste without having to change anything. For example, transposing rows for columns, or something?spinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
where is B54 and B55???!spinwizard wrote:no, this is my formula-Gen Monty wrote:Ctrl C to copy the cellspinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
Crtl V to paste the cellbut i want it to be-Code: Select all
=B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43+B44+B46+B45+B47+B48+B49+B50+B51+B52+B53(in another cell)Code: Select all
=B56+B57+B58.....
Headingschessplaya wrote:where is B54 and B55???!spinwizard wrote:no, this is my formula-Gen Monty wrote:Ctrl C to copy the cellspinwizard wrote:I am doing a massive spreadsheet but i dont want to enter the same (but with different cells) formula in 25 times as it is a large formula, i cant drag it down as the cells i want the formula to include are not adjacent, HELP!
Crtl V to paste the cellbut i want it to be-Code: Select all
=B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43+B44+B46+B45+B47+B48+B49+B50+B51+B52+B53(in another cell)Code: Select all
=B56+B57+B58.....
Why on Earth don't you put SUM(B31:B53)?? Changing the other formulas would then be a cinch.spinwizard wrote: no, this is my formula-but i want it to be-Code: Select all
=B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43+B44+B46+B45+B47+B48+B49+B50+B51+B52+B53(in another cell)Code: Select all
=B56+B57+B58.....
because i did not know u can do that, i don't use excel much, THANKSStopper wrote:Why on Earth don't you put SUM(B31:B53)?? Changing the other formulas would then be a cinch.spinwizard wrote: no, this is my formula-but i want it to be-Code: Select all
=B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43+B44+B46+B45+B47+B48+B49+B50+B51+B52+B53(in another cell)Code: Select all
=B56+B57+B58.....
No problem. I always had faith that 10 years of continually working with Excel would actually be of some use to someone outside of work, one day.spinwizard wrote:
because i did not know u can do that, i don't use excel much, THANKS
Stopper wrote:No problem. I always had faith that 10 years of continually working with Excel would actually be of some use to someone outside of work, one day.spinwizard wrote:
because i did not know u can do that, i don't use excel much, THANKS
Code: Select all
=SUM($B$31:$B$58)
The dollar signs makes the cell positions absolute, so when you copy the formula to another cell, the formula continues to point to B31:B58, as you have it. Very useful sometimes, but not here (if I understood spin correctly).Fircoal wrote:Spin here:
Then copy and paste and it should do it for you.Code: Select all
=SUM($B$31:$B$58)
EDIT: Nevermind, I think it has to be the long way for that to work.
Oh yeah.Stopper wrote:The dollar signs makes the cell positions absolute, so when you copy the formula to another cell, the formula continues to point to B31:B58, as you have it. Very useful sometimes, but not here (if I understood spin correctly).Fircoal wrote:Spin here:
Then copy and paste and it should do it for you.Code: Select all
=SUM($B$31:$B$58)
EDIT: Nevermind, I think it has to be the long way for that to work.
Live long, and prosper.
*Spaceship launches*
](./images/smilies/eusa_wall.gif "Brick wall"){kind=small}