AVERAGEIF Function in Excel 2003

I have data that i need to average. In Excel 2007 there seems to be a function to do this but it isnt available in 2003 version.

In column A there is a load number in column B there is a total load time, i need to be able to calculate an average load time.

Any help much appreciated

Mat Brown

Thanks for your reply, I have tried the formula but it returned the same value as in column B not an average load time/load number?

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.

Perhaps try like this (see attached)

I amended Donkey's formula to only display on the first row of each section, i.e. this formula in C2

=IF(A1<>A2,AVERAGE(IF($A$2:$A$16=$A2,$B$2:$B$16)),"")