AVERAGEIF Function in Excel 2003

I would expect the results to be as follows

That wouldn't be an average by normal standards, usually you total all the entries and divide by the number so you have 5 * 10 hours = 50 hours divided by 5 = 10 hours.

If every load took 10 hours then the average time is also 10 hours......or is there something here I don't understand?

Hi I have included more info to try and help in the attachment.

The load 01000 for eg appears 5 times in the table, the total load time is the sum of all the individual car times.

The average that i need help with is partly because of how the data presented which is shown in bottom table. To get the average it will need to = the total load time / 5 (number of replicants or times the same load appears in table)

Thanks for your patience.

It works!, I will try to be more precise in future.

Thanks very much