Excel Help

by **spinwizard** on Sun May 27, 2007 10:43 am

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!

by **chessplaya** on Sun May 27, 2007 10:44 am

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!

by **wcaclimbing** on Sun May 27, 2007 10:45 am

copy paste?

by **chessplaya** on Sun May 27, 2007 10:46 am

wcaclimbing wrote:copy paste?

yes or that

by **Gen Monty** on Sun May 27, 2007 10:47 am

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

by **Stopper** on Sun May 27, 2007 10:49 am

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?

by **spinwizard** on Sun May 27, 2007 10:50 am

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)

by **spinwizard** on Sun May 27, 2007 10:53 am

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?

by **chessplaya** on Sun May 27, 2007 10:53 am

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 !

by **spinwizard** on Sun May 27, 2007 10:53 am

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

by **Stopper** on Sun May 27, 2007 10:54 am

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.

by **spinwizard** on Sun May 27, 2007 10:56 am

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

by **Stopper** on Sun May 27, 2007 11:01 am

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.

by **wicked** on Sun May 27, 2007 11:03 am

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.

by **Aegnor** on Sun May 27, 2007 11:05 am

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.

by **Fircoal** on Sun May 27, 2007 11:07 am

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.

by **Stopper** on Sun May 27, 2007 11:17 am

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*

by **Fircoal** on Sun May 27, 2007 11:27 am

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*