| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Average ? | Excel Discussion (Misc queries) | |||
| simple average question | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple average question | New Users to Excel | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Linear Mode
