for your example
=SUMIF(B1:B6,A11,A1:A6)/COUNTIF(B1:B6,A11)
a11 is any cell where you type your name you want the results for
--
paul

remove nospam for email addy!



"CraigSA" wrote:

I have a table with various fields of information in each cell.
one column has a list of names, these are repeated randomly throughout the
column.
i want to creat a chart from information relating to each name. So I need to
search through the list and wherever the name entry equals for example, aaa
in column b, i need the related info for each maching name from column A.

So if i have:
1 aaa
2 bbb
3 ccc
4 aaa
5 aaa
6 ccc

I need to use values 1, 4 and 5 relating to aaa only to for example,
calculate an average for aaa.