Average Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 56 Names in Column #1. After each name, there are
various numbers in each row. What I am looking for, is the formula to give
the average of each row, for each of the names in column 1. Any help would
be greatly appreciated.
 
Assuming the names are all unique (ie you want to average the values on each
individual row)

=SUM(B2:G2)/COUNT(B2:G2)
 
=AVERAGE(C2:M2)

assuming the numbers start in C and end in M

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top