Hi Friends,
I want to calculate the Average from the list of name and numbers(Horizontal list).

e.g. I have 10 names like abc, bbc, ddc, xyz and they have their own earned numbers now what I want is:-

=if("A1:z1"="abc", average("A1:z1"),0) - now this average will show me abc's earned average numbers.

is it possible.......???

Please help.

Regards,
Ravi