Excel Help

[spinwizard]

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!

[chessplaya]

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!

[wcaclimbing]

copy paste?

[chessplaya]

copy paste?

yes or that

[Gen Monty]

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

[Stopper]

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]

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)

[spinwizard]

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?

[chessplaya]

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 !

[spinwizard]

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

[Stopper]

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.

[spinwizard]

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

[Stopper]

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.

[wicked]

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.

[Aegnor]

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.

[Fircoal]

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.

[Stopper]

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*

[Fircoal]

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.