Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 06, 09:17 PM posted to microsoft.public.excel.newusers
Newguy123
 
Posts: n/a
Default Simple average question


I am tracking 32 sports teams. I have various stats the I would like to
get averages from. Each team is on a row from 4-35. In column E are
total yards, column F is total attempts, I would like column G to be
the average, I would like the formula to calculate it for each
individual team.


--
Newguy123
------------------------------------------------------------------------
Newguy123's Profile: http://www.excelforum.com/member.php...o&userid=31117
View this thread: http://www.excelforum.com/showthread...hreadid=507860


  #2   Report Post  
Old February 2nd 06, 09:28 PM posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default Simple average question

So, likely:
=E2/F2
This should tell you how many yards per attempt.
Copy the formula down.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Newguy123" wrote
in message ...

I am tracking 32 sports teams. I have various stats the I would like to
get averages from. Each team is on a row from 4-35. In column E are
total yards, column F is total attempts, I would like column G to be
the average, I would like the formula to calculate it for each
individual team.


--
Newguy123
------------------------------------------------------------------------
Newguy123's Profile:
http://www.excelforum.com/member.php...o&userid=31117
View this thread: http://www.excelforum.com/showthread...hreadid=507860



  #3   Report Post  
Old February 2nd 06, 11:17 PM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Simple average question

In cell G4 type this formula

=E4/F4

Then right-click on the cell and select Copy, then left-click on cell G5 and
holld the left button down while dragging the cursor down column G to
highlight all cells to cell G35.....then release the left button and
right-click and select Paste......the entire column should fill in with the
respective formullas to give you the averages you seek in column G

Vaya con Dios,
Chuck, CABGx3


"Newguy123" wrote
in message ...

I am tracking 32 sports teams. I have various stats the I would like to
get averages from. Each team is on a row from 4-35. In column E are
total yards, column F is total attempts, I would like column G to be
the average, I would like the formula to calculate it for each
individual team.


--
Newguy123
------------------------------------------------------------------------
Newguy123's Profile:

http://www.excelforum.com/member.php...o&userid=31117
View this thread: http://www.excelforum.com/showthread...hreadid=507860





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pretty simple question Alex Excel Discussion (Misc queries) 5 August 30th 06 02:13 PM
Average function question chapm4 Excel Worksheet Functions 4 January 11th 06 10:44 PM
Pivot table question gary Excel Discussion (Misc queries) 1 January 10th 06 07:25 PM
this may be simple, sumif question jim sturtz Excel Worksheet Functions 3 August 22nd 05 03:11 PM
simple chart question Shooter Excel Worksheet Functions 1 July 26th 05 06:48 PM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017