Hi I am using the formula average(start:end!b4) to calculate average for
sales people. The problem I have is all the sales person's names are not in
the same order in Column A for every sheet.

How do I write a formula to calculate average of all 4 sheets if the sales
person's name is not in the same order without moving and copying it over to
the same line etc.

Thanks

Fawn