finding avg in list with same name

[xpostie]

Hi there. Im trying to figure out how to do this. I have a list of people with different categories. I want to find say Bob Jones and all his scores and do a average. Not quite sure how to go about this.

here is an example

Bob Jones 34
Steve Smith 44
Bob Jones 55
Harry Twist 22
Bob Jones 52
Bob jones avg. ??

Hope you understand what Im trying to do. Im trying to take all of Bob Jones scores from the list ignoring the other names and average it out. I know it can be done just confused on the right way to go about it.

Thanks in advance to any help
Tom

[vlady]

Hello
try
Column A the names and Column B are the scores.
=AVERAGE(IF(A1:A100="Bob Jones",B1:B100,"")) - ctrl + shift + enter not just enter..

[benishiryo]

hi xpostie, since u are using Excel 2003, u can try:
=SUMIF($A$1:$A$5,"Bob Jones",$B$1:$B$5)/COUNTIF($A$1:$A$5,"Bob Jones")

in Excel 2007, there is a new formula called AVERAGEIF:
=AVERAGEIF($A$1:$A$5,"Bob Jones",$B$1:$B$5)

let me know if this is what u need

[Fotis1991]

Hi Tom

As you are in 2003, try these 2 ways.

=SUMIF(A1:A3,"A",B1:B3)/COUNTIF(A1:A3,"A")

Or this Array formula(Control+Shift+Enter) No just Enter.

=AVERAGE(IF(A1:A3="A",B1:B3))

"A", is the Name that you want.

Are these, work for you?

[xpostie]

Hi benishiryo. thanks yes using Excel 2003 and that works.

hi xpostie, since u are using Excel 2003, u can try:
=SUMIF($A$1:$A$5,"Bob Jones",$B$1:$B$5)/COUNTIF($A$1:$A$5,"Bob Jones")

in Excel 2007, there is a new formula called AVERAGEIF:
=AVERAGEIF($A$1:$A$5,"Bob Jones",$B$1:$B$5)

let me know if this is what u need

[benishiryo]

glad to help. =)
could u Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved. thanks

[Fotis1991]

@ Vlady

Why do you use the invisible ink when you type?

[vlady]

I t hi n k m y ke y boar d is s tu ck ed up soory