Excel help

VintagePunk · 02-15-2006, 09:38 AM

Okay, so I'm a complete idiot and I've never learned to use Excel.

I need to do what should be two very simple tasks. I've tried the help feature, and don't understand the instructions, or even if I'm asking the right question.

1) I need to add rows of variables, from variable E to Y. Should be pretty simple, right?

2) Ideally, it would be good if I could decrease each variable by one, if possible, before I add. I.E.: 1 becomes 0, 2 becomes 1, etc. This is not necessary however. The main thing is to figure out how to add them. As long as I can do that, I can make this adjustment mentally.

karls77 · 02-15-2006, 09:48 AM

Don't know about reducing the variables by one but it sounds like you need to use the "SUM" feature i.e. "=SUM(B6:I6)"

This will add the amounts in cells B6 thru I6, modify as necessary.

VintagePunk · 02-15-2006, 10:04 AM

I found the function that you mean. I think you're overestimating my know-how, though.

I need to add 444 rows of variables E to Y. What exactly should I type in between the brackets?

Thanks so much.

UberBeaver · 02-15-2006, 10:07 AM

Put the curser down on the cell below the list. On the toolbar there should be a Greek E looking thing? Click that. Then highlight what you want to add up, and then click the = to the left of the address bar.

VintagePunk · 02-15-2006, 10:14 AM

That was really easy.

Thank you!

UberBeaver · 02-15-2006, 10:18 AM

If you want to do the -1 thing, go to the box to the right of the cell. So if 7 is in A1, go to B1. Click the Greek E, highlight A1, and type SUM(A1)-1. CLick the equal sign. Now, this is the tricky part: Click B1 once. The border of the cell changes, right? The lower right corner should be a bit different than the other corners. Put the cursor over that and then either double click, or drag it down. This will copy the forumla all the way down.

VintagePunk · 02-15-2006, 10:37 AM

You rock! Thanks again

redkat · 02-15-2006, 10:40 AM

I'm bookmarking this thread

I suck at excel

VintagePunk · 02-15-2006, 10:46 AM

Quote:

Originally posted by redkat
I'm bookmarking this thread

I suck at excel

It's kinda necessary when sorting through data, isn't it?

Now if only I could find an expert in SPSS, I'd be all set.

UberBeaver · 02-15-2006, 02:52 PM

It makes me sad that I'm rather proficient with Excel.

Achtung_Bebe · 02-15-2006, 03:17 PM

Quote:

Originally posted by VintagePunk
Now if only I could find an expert in SPSS, I'd be all set.

ahck, you won't find one in me. SPSS, to me, stands for Some Pretty Shitty Software.

VintagePunk · 06-18-2006, 01:36 PM

Again, help!

New issue, this time. Anyone out there that's proficient with this program?

~BrightestStar~ · 06-18-2006, 02:47 PM

VP darling, I'm no expert, but email me if you like and I'll do what I can.

VintagePunk · 06-18-2006, 03:39 PM

Quote:

Originally posted by ~BrightestStar~
VP darling, I'm no expert, but email me if you like and I'll do what I can.

I had msn open hoping for an Excel genius to appear, why didn't you log on?

Thanks, I managed to muddle through manually. Only took me 3 hours this time.

Excel

~BrightestStar~ · 06-18-2006, 04:27 PM

Quote:

Originally posted by VintagePunk

I had msn open hoping for an Excel genius to appear, why didn't you log on?

Thanks, I managed to muddle through manually. Only took me 3 hours this time.

Excel

Because I was vaccuuming.

Why didn't you check here sooner?

Glad you figured it ot!

Exel.

VintagePunk · 06-18-2006, 05:08 PM

Because I was busy doing it all manually.

But I'm done, and I've just sent out 105 e-mails to P's.

Hopefully I'll get a lot of responses fast, and I can catch up so that S won't realize I've been slacking for the past month.

~BrightestStar~ · 06-18-2006, 05:47 PM

You slack?!?!

VintagePunk · 06-18-2006, 05:49 PM

Hard to believe, isn't it?

~BrightestStar~ · 06-18-2006, 05:59 PM

I *never* would have guessed!

Frankly, I'm shocked, stunned and appalled.
You should be ashamed.

I would never do such a thing...

02-15-2006, 09:38 AM	#1
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	Excel help Okay, so I'm a complete idiot and I've never learned to use Excel. I need to do what should be two very simple tasks. I've tried the help feature, and don't understand the instructions, or even if I'm asking the right question. 1) I need to add rows of variables, from variable E to Y. Should be pretty simple, right? 2) Ideally, it would be good if I could decrease each variable by one, if possible, before I add. I.E.: 1 becomes 0, 2 becomes 1, etc. This is not necessary however. The main thing is to figure out how to add them. As long as I can do that, I can make this adjustment mentally. __________________

02-15-2006, 09:48 AM	#2
karls77 War Child Join Date: Jan 2005 Location: Southeast UK (formerly Tucson, AZ) Posts: 689 Local Time: 10:24 PM	Don't know about reducing the variables by one but it sounds like you need to use the "SUM" feature i.e. "=SUM(B6:I6)" This will add the amounts in cells B6 thru I6, modify as necessary. __________________

06-18-2006, 05:59 PM	#19
~BrightestStar~ Blue Crack Supplier Join Date: Jan 2005 Location: Gettin' hot in a photobooth....livin it up in Ikeaville Posts: 35,735 Local Time: 06:24 PM	I never would have guessed! Frankly, I'm shocked, stunned and appalled. You should be ashamed. I would never do such a thing... __________________

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-15-2006, 10:04 AM	#3
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	I found the function that you mean. I think you're overestimating my know-how, though. I need to add 444 rows of variables E to Y. What exactly should I type in between the brackets? Thanks so much.

02-15-2006, 10:07 AM	#4
UberBeaver Breakdancing Soul Pilgrim Join Date: Sep 2005 Location: the most serious...douch hammer ever Posts: 20,318 Local Time: 05:24 PM	Put the curser down on the cell below the list. On the toolbar there should be a Greek E looking thing? Click that. Then highlight what you want to add up, and then click the = to the left of the address bar.

02-15-2006, 10:14 AM	#5
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	That was really easy. Thank you!

02-15-2006, 10:18 AM	#6
UberBeaver Breakdancing Soul Pilgrim Join Date: Sep 2005 Location: the most serious...douch hammer ever Posts: 20,318 Local Time: 05:24 PM	If you want to do the -1 thing, go to the box to the right of the cell. So if 7 is in A1, go to B1. Click the Greek E, highlight A1, and type SUM(A1)-1. CLick the equal sign. Now, this is the tricky part: Click B1 once. The border of the cell changes, right? The lower right corner should be a bit different than the other corners. Put the cursor over that and then either double click, or drag it down. This will copy the forumla all the way down.

02-15-2006, 10:37 AM	#7
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	You rock! Thanks again

02-15-2006, 10:40 AM	#8
redkat Blue Crack Addict Join Date: Apr 2005 Location: racing to the waterside Posts: 19,620 Local Time: 03:24 PM	I'm bookmarking this thread I suck at excel

02-15-2006, 02:52 PM	#10
UberBeaver Breakdancing Soul Pilgrim Join Date: Sep 2005 Location: the most serious...douch hammer ever Posts: 20,318 Local Time: 05:24 PM	It makes me sad that I'm rather proficient with Excel.

06-18-2006, 01:36 PM	#12
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	Again, help! New issue, this time. Anyone out there that's proficient with this program?

06-18-2006, 02:47 PM	#13
~BrightestStar~ Blue Crack Supplier Join Date: Jan 2005 Location: Gettin' hot in a photobooth....livin it up in Ikeaville Posts: 35,735 Local Time: 06:24 PM	VP darling, I'm no expert, but email me if you like and I'll do what I can.

06-18-2006, 05:08 PM	#16
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	Because I was busy doing it all manually. But I'm done, and I've just sent out 105 e-mails to P's. Hopefully I'll get a lot of responses fast, and I can catch up so that S won't realize I've been slacking for the past month.

06-18-2006, 05:47 PM	#17
~BrightestStar~ Blue Crack Supplier Join Date: Jan 2005 Location: Gettin' hot in a photobooth....livin it up in Ikeaville Posts: 35,735 Local Time: 06:24 PM	You slack?!?!

06-18-2006, 05:49 PM	#18
VintagePunk Blue Crack Distributor Join Date: Jan 2005 Location: In a dry and waterless place Posts: 55,743 Local Time: 05:24 PM	Hard to believe, isn't it?