Dumb Excel (program not person) question

[Yetskii]

OMG I have not used excel in years..

anyways simple sum(b3:b11) in b12

How can I make a whole bunch of rows do this so I do not have to keep fucking doing the formula manually...have about 50 rows to do this to

same with sum(b12-b13) in b14

I feel retarded right about now....should not have smoked that pot...

 

[telos]

grab the lower right corner and drag if it just horizontal. If all of your columns are different heights put the sum below the tallest one. If the heights are too different put them at the top for ease of use.

 

[DMAUL]

drag it across?

 

[mjoe]

doesn't seem like you can drag it across if you have all your data in column B

 

[Spxnge]

i'm not following your explanation

 

[telos]

from the sounds of it he has 9 data points in each column. row 3-11. he wants to sum these in 12 then subtract a value in 13 from that and put it in 14.

He should just be able to drag if his columns are the same height.

 

[Yetskii]

grab the lower right corner and drag if it just horizontal. If all of your columns are different heights put the sum below the tallest one. If the heights are too different put them at the top for ease of use.

Yeah that did it..I feel stupid

 

[mjoe]

yep, stupid

 

[Teratos]

We need a screenshot or a diagram or something.

 

[soundjester]

you'll need to install the XCOM module.

 

[motoxbudd]

$

 

[Midnj]

ASAP Utilities - The essential add-in for Excel users. FREE excel tools and macros to save time. Download Excel tools - Excel software

 

[kMz.]

christ