Calculate avarage of specific cells

[TimvMechelen]

Hi all,

I'd like to calculate the avarage times of the cells corresponding to the A number in the next column. So the avarage time of A1, A2 and A3 in the example given in the link below.

https://www.dropbox.com/s/sv1wrqoaa6r2n6n/Example.xlsx?dl=0


I have almost 700 rows, so I can't do it all manually.

I hope somebody can help me with this formula.

Thanks for your help

 

[Jonmo1]

Try the AverageIf function

=AVERAGEIF(B:B,E7,C:C)

Just put the text A1 in E7, not the whole sentence 'Average time A1'