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=507849

Simple average question.
 

In G4 put "=E4/F4" (without quotes). Copy down to G35

"Newguy123" wrote:


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=507849

Simple average question.
 

In G4 enter:
=E4/F4 and copy down
This give the average yards per attempt
--
Gary's Student


"Newguy123" wrote:


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=507849

Simple average question.
 

Sorry if I asked a question in the wrong forum

--
Newguy12
-----------------------------------------------------------------------
Newguy123's Profile: http://www.excelforum.com/member.php...fo&userid=3111
View this thread: http://www.excelforum.com/showthread.php?threadid=50784

Simple average question.
 

Thank you for your help. :

--
Newguy12
-----------------------------------------------------------------------
Newguy123's Profile: http://www.excelforum.com/member.php...fo&userid=3111
View this thread: http://www.excelforum.com/showthread.php?threadid=50784

Simple average question.
 

Bob,

Range("a1").copy range("b1") <=== B1 takes properties of A1

Range("b1")=Range("a1") <=== B1 retains its properties

HTH

"Newguy123" wrote:


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=507849