Simple average question.

  • Thread starter Thread starter Newguy123
  • Start date Start date
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.
 
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
find an exact number in a different sheet and use the cell containing the number to output informati 4
Trying to find averages based on date. 1
Excel Sumproduct 0
Average Question 2
Pro Football formula automation 2
select range in column, calculate on range plus 3 columns, output inrange plus 7 columns 8
Totalling then Averaging subject to Product Code change 3

Back
Top