Simple average question.

N

Newguy123

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.
 
G

Gary''s Student

In G4 enter:
=E4/F4 and copy down
This give the average yards per attempt
 
T

Toppers

Bob,

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

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

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple average question 2
Average Question 2
Sports question. Finding points scored by specific team 2
Averaging Formula 8
Finding the weighted average of text that have been given values 1
select range in column, calculate on range plus 3 columns, output inrange plus 7 columns 13
find an exact number in a different sheet and use the cell containing the number to output informati 4
Totalling then Averaging subject to Product Code change 6

Top