Conquer Club

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!

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!

ummmm , use the vlookup function ?? i am not sure cuz i didnt understand u correctly!

copy paste?

wcaclimbing wrote:copy paste?

yes or that

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!

Ctrl C to copy the cell
Crtl V to paste the cell

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!

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?

Gen Monty wrote:

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!

Ctrl C to copy the cell
Crtl V to paste the cell

no, this is my formula-

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

but i want it to be-

Code: Select all

=B56+B57+B58.....

(in another cell)

Stopper wrote:

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!

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?

would it work 4 my example?

spinwizard wrote:

Gen Monty wrote:

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!

Ctrl C to copy the cell
Crtl V to paste the cell

no, this is my formula-

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

but i want it to be-

Code: Select all

=B56+B57+B58.....

(in another cell)

where is B54 and B55???!

and i think just click on the bottom right of the cell and drag it down u should be ok !

chessplaya wrote:

spinwizard wrote:

Gen Monty wrote:

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!

Ctrl C to copy the cell
Crtl V to paste the cell

no, this is my formula-

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

but i want it to be-

Code: Select all

=B56+B57+B58.....

(in another cell)

where is B54 and B55???!

Headings

spinwizard wrote:no, this is my formula-

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

but i want it to be-

Code: Select all

=B56+B57+B58.....

(in another cell)

Why on Earth don't you put SUM(B31:B53)?? Changing the other formulas would then be a cinch.

Stopper wrote:

spinwizard wrote:no, this is my formula-

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

but i want it to be-

Code: Select all

=B56+B57+B58.....

(in another cell)

Why on Earth don't you put SUM(B31:B53)?? Changing the other formulas would then be a cinch.

because i did not know u can do that, i don't use excel much, THANKS

spinwizard wrote:
because i did not know u can do that, i don't use excel much, THANKS

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.

Spin, click on the cell you want the formula in, then click on the summation symbol in your toolbar (looks like an E), then highlight the cells you want to sum. Or, you can type =Sum(cell range) instead, where cell range is B54:B57 or whatever.

Stopper wrote:

spinwizard wrote:
because i did not know u can do that, i don't use excel much, THANKS

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.

I think your mission on this planet is done. You are free to return home.

Spin here:

Code: Select all

=SUM($B$31:$B$58)

Then copy and paste and it should do it for you.

EDIT: Nevermind, I think it has to be the long way for that to work.

Fircoal wrote:Spin here:

Code: Select all

=SUM($B$31:$B$58)

Then copy and paste and it should do it for you.

EDIT: Nevermind, I think it has to be the long way for that to work.

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).

Live long, and prosper.

*Spaceship launches*

Stopper wrote:

Fircoal wrote:Spin here:

Code: Select all

=SUM($B$31:$B$58)

Then copy and paste and it should do it for you.

EDIT: Nevermind, I think it has to be the long way for that to work.

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).

Live long, and prosper.

*Spaceship launches*

Oh yeah.