Matching names between different sheets and getting averages

[Climaxgp]

Hi Guys

I need to get the averages from January to April per individual in the sheet called Overview.

The problem is that the names are not in order from January to April.

So i need to match the names from January to April in the Overview Sheet and get the average per individual.

[DonkeyOte]

To keep formulae lightweight you should create an intermediate table to retrieve values from each sheet separately (SUMIF) and average based on those results.

The other alternatives are both expensive & volatile (and complicated by the fact that the sheets are not identical - ie results in different columns).

EDIT: to elaborate... see attached (note assumed pre XL2007)

[Climaxgp]

DonkeyOte you are a STAR!!!!!!!

Thank you soooooo much!!!!!!

Really, really, really appreciate it!!

I cannot tip your scales, it does'nt allow me to!!

[Climaxgp]

Hi DonkeyOte

Was just checking the stuff again and noticed that the names in A2 of the Overview does not correspond with the averages of the same person over the months.

[DonkeyOte]

Can you clarify by means of example ?

I used the final column as source for the monthly average values - if that's not the correct column to use then adjust the formulae in J1 (to M1) accordingly.