average whole column if header matches criteria

[doylzer]

Hi, This is my first post! So bear with me!

I have a list of people names and i want to be able to get the average of each by changing the drop down in C15. So I was hoping to have the formula running over all the table.
So that if I pick John i will get the average figure for all the number under John header.

Thanks. I have attached my file.

[XOR LX]

Hi.

=AVERAGE(INDEX(A2:I11,,MATCH(C15,A1:I1,0)))

Regards

[samba_ravi]

=AVERAGE(INDEX($A$2:$I$11,,MATCH($C15,$A$1:$I$1,0)))
Try this formula

[martindwilson]

in d15
=AVERAGE(INDEX($A$1:$I$11,0,MATCH($C$15,$A$1:$I$1,0)))

[boopathiraja]

Try with the below array formula to be entered with ctrl+shift+enter

Please Login or Register  to view this content.

[sweep]

Hi,

Using your example

=AVERAGE(INDEX(A2:I2,MATCH(C15,A1:I1,0)):INDEX(A11:I11,MATCH(C15,A1:I1,0)))

Where

A1:I1 contains the header
A2:I2 contains the first row of data
A11:I11 contains the last row of data

[doylzer]

OMG thanks everyone, so impressed with the speed and accuracy.
ill defo be using this page alot more.
Cheers