Average formula

[Adrac]

Hello All,

I have a table with a list of names in column A and % in column B. I would like to know the average % of Sam. Then like wise with john.

A
John - 40%
Sam - 50%
Sam - 30%
Sam - 10%
John - 25%

I'm sure this is a simple formula but I cant seem to get it right. Can you help?

 

[Marcelo Branco]

Try

=AVERAGEIF(A1:A5,"Sam",B1:B5)

M.

 

[t0azt]

Nevermind. Solved

 

[Marcílio_Lobão]

Adrac, Good afternoon.

Try to use:

=AVERAGEIF(A1:A100,"SAM",B1:B100)

Is that what you want?
I hope it helps.

P.s. --> delayed message.

 

[Adrac]

Perfect thank you all.