Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Formula
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Formula
=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) "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Formula | Excel Discussion (Misc queries) | |||
Average formula | Excel Discussion (Misc queries) | |||
formula average | Excel Discussion (Misc queries) | |||
Average Formula | Excel Discussion (Misc queries) | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions |