Averaging a number and counting person

[phillexcel]

Stuck with this one, I'm wondering if anyone can help?

B2:B349 shows a person's name, for example 'Alex'

I2:I349 shows a number

In cell G371 what I need is the average of those numbers taken from the cells In I2:I349 but only if the cell in B349 shows that persons name (for this example Alex)

 

[VoG]

If Excel 2007or later try

=AVERAGEIF(B2:B349,"Alex",I2:I349)

 

[phillexcel]

Bingo! Cheers pal

 

[phillexcel]

How do you get it to ignore DIVO and replace with a blank cell with this formula?

 

[VoG]

Try
=IFERROR(AVERAGEIF(B2:B349,"Alex",I2:I349),"")

 

[phillexcel]

Try
=IFERROR(AVERAGEIF(B2:B349,"Alex",I2:I349),"")

Perfect, thanks.