need some Excel help - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 9 (permalink) Old 04-30-2009, 08:37 AM Thread Starter
que?
 
grove rat's Avatar
 
Join Date: Jun 2003
Posts: 21,662
need some Excel help

i need the "Average" column to average out the numbers to the left and place the number in the apprioate space

i am a complete noob to Excel but wanna start getting into little by little

thanks for any help

grove rat is offline  
Sponsored Links
Advertisement
 
post #2 of 9 (permalink) Old 04-30-2009, 08:42 AM
AHMO!
 
Join Date: Apr 2004
Location: the original let me google that for ya guy
Posts: 16,810
What do you mean place the #'s in the appropriate space? shoot me an email with the spreadsheet [email protected] and I'll average it and show you the formula you need.
Nate is offline  
post #3 of 9 (permalink) Old 04-30-2009, 08:50 AM Thread Starter
que?
 
grove rat's Avatar
 
Join Date: Jun 2003
Posts: 21,662
Quote:
Originally Posted by NaSSty Nate View Post
What do you mean place the #'s in the appropriate space? shoot me an email with the spreadsheet [email protected] and I'll average it and show you the formula you need.
let's say the average for number 2 chiller is 815(wild guess)

isn't there a way to have it automatically average it out?

i'll send the email also
grove rat is offline  
 
post #4 of 9 (permalink) Old 04-30-2009, 08:52 AM
AHMO!
 
Join Date: Apr 2004
Location: the original let me google that for ya guy
Posts: 16,810
Yeah I'll show you the formula and explain it in email.
Nate is offline  
post #5 of 9 (permalink) Old 04-30-2009, 08:52 AM Thread Starter
que?
 
grove rat's Avatar
 
Join Date: Jun 2003
Posts: 21,662
Quote:
Originally Posted by NaSSty Nate View Post
Yeah I'll show you the formula and explain it in email.
thanks man
grove rat is offline  
post #6 of 9 (permalink) Old 04-30-2009, 08:54 AM
Time Served
 
Join Date: May 2002
Location: garland
Posts: 568
put "=SUM(B5:M5)/12" in cell N5 that will average the numbers you currently have.
Then just change the "BX:NX" part, where X is the row you want to average. So the next row, N6, will be "=SUM(B6:M6)/12" and so on..
heavychevy is offline  
post #7 of 9 (permalink) Old 04-30-2009, 08:55 AM
Lifer
 
Join Date: Jul 2000
Location: Rowlett, TX
Posts: 1,463
Calculate the average of numbers in a contiguous row or column
Click a cell below or to the right of the numbers for which you want to find the average.
Click the arrow next to AutoSum on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), and then click Average and press ENTER.
Way Cool Jr is offline  
post #8 of 9 (permalink) Old 04-30-2009, 08:57 AM
AHMO!
 
Join Date: Apr 2004
Location: the original let me google that for ya guy
Posts: 16,810
Quote:
Originally Posted by heavychevy View Post
put "=SUM(B5:M5)/12" in cell N5 that will average the numbers you currently have.
Then just change the "BX:NX" part, where X is the row you want to average. So the next row, N6, will be "=SUM(B6:M6)/12" and so on..
Or he can use the Average function and then click and autofill the other columns...just seems easier to me.
Nate is offline  
post #9 of 9 (permalink) Old 04-30-2009, 08:59 AM
Time Served
 
Join Date: May 2002
Location: garland
Posts: 568
haha yea, i dont think i've used excel since highschool. That was the only way i could remember..
heavychevy is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome