Average Formula

W

wannabe68

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

Ian

Assuming the names are all unique (ie you want to average the values on each
individual row)

=SUM(B2:G2)/COUNT(B2:G2)
 
B

Bob Phillips

=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)
 
Top