Thread: Average Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Average Formula

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

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

--
Ian
--
"wannabe68" wrote in message
...
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.