Excel help - U2 Feedback

Go Back   U2 Feedback > ZOOTV > Restart and Reboot Yourself
Click Here to Login
Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-15-2006, 10:38 AM   #1
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 AM
crys 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.
__________________

__________________
VintagePunk is offline   Reply With Quote
Old 02-15-2006, 10:48 AM   #2
War Child
 
karls77's Avatar
 
Join Date: Jan 2005
Location: Southeast UK (formerly Tucson, AZ)
Posts: 689
Local Time: 12:18 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.
__________________

__________________
karls77 is offline   Reply With Quote
Old 02-15-2006, 11:04 AM   #3
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 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.
__________________
VintagePunk is offline   Reply With Quote
Old 02-15-2006, 11:07 AM   #4
Breakdancing Soul Pilgrim
 
UberBeaver's Avatar
 
Join Date: Sep 2005
Location: the most serious...douch hammer ever
Posts: 20,318
Local Time: 07:18 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.
__________________
UberBeaver is offline   Reply With Quote
Old 02-15-2006, 11:14 AM   #5
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 AM
That was really easy.

Thank you!
__________________
VintagePunk is offline   Reply With Quote
Old 02-15-2006, 11:18 AM   #6
Breakdancing Soul Pilgrim
 
UberBeaver's Avatar
 
Join Date: Sep 2005
Location: the most serious...douch hammer ever
Posts: 20,318
Local Time: 07: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.
__________________
UberBeaver is offline   Reply With Quote
Old 02-15-2006, 11:37 AM   #7
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 AM
You rock! Thanks again
__________________
VintagePunk is offline   Reply With Quote
Old 02-15-2006, 11:40 AM   #8
Blue Crack Addict
 
redkat's Avatar
 
Join Date: Apr 2005
Location: racing to the waterside
Posts: 19,620
Local Time: 05:18 AM
I'm bookmarking this thread

I suck at excel
__________________
redkat is offline   Reply With Quote
Old 02-15-2006, 11:46 AM   #9
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 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.
__________________
VintagePunk is offline   Reply With Quote
Old 02-15-2006, 03:52 PM   #10
Breakdancing Soul Pilgrim
 
UberBeaver's Avatar
 
Join Date: Sep 2005
Location: the most serious...douch hammer ever
Posts: 20,318
Local Time: 07:18 AM
It makes me sad that I'm rather proficient with Excel.
__________________
UberBeaver is offline   Reply With Quote
Old 02-15-2006, 04:17 PM   #11
New Yorker
 
Achtung_Bebe's Avatar
 
Join Date: Jul 2000
Location: Beneath the noise, below the din
Posts: 2,859
Local Time: 06:18 AM
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.
__________________
Achtung_Bebe is offline   Reply With Quote
Old 06-18-2006, 02:36 PM   #12
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 AM
Again, help! New issue, this time. Anyone out there that's proficient with this program?
__________________
VintagePunk is offline   Reply With Quote
Old 06-18-2006, 03:47 PM   #13
Blue Crack Supplier
 
~BrightestStar~'s Avatar
 
Join Date: Jan 2005
Location: Gettin' hot in a photobooth....livin it up in Ikeaville
Posts: 35,735
Local Time: 08:18 AM
VP darling, I'm no expert, but email me if you like and I'll do what I can.
__________________
~BrightestStar~ is offline   Reply With Quote
Old 06-18-2006, 04:39 PM   #14
Blue Crack Distributor
 
VintagePunk's Avatar
 
Join Date: Jan 2005
Location: In a dry and waterless place
Posts: 55,732
Local Time: 07:18 AM
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
__________________
VintagePunk is offline   Reply With Quote
Old 06-18-2006, 05:27 PM   #15
Blue Crack Supplier
 
~BrightestStar~'s Avatar
 
Join Date: Jan 2005
Location: Gettin' hot in a photobooth....livin it up in Ikeaville
Posts: 35,735
Local Time: 08:18 AM
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.
__________________

__________________
~BrightestStar~ is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 07:18 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com