Simple Excel Help with Averages

[ljnorton]

Sorry but got a bit of a mind blank.

I know it probably really simple but can someone please help with my problem below:

On Sheet 1 I have my data:
ID Colour Images
6 Red 0
6 Blue 6
6 Green 8
6 Yellow 6
482 Red 9
482 Blue 7
491 Red 20
491 Yellow 20
684 Blue 9
684 Yellow 10
1519 Green 15
1548 Blue 10



On sheet 2 I have:
ID Average Images
6
482
491
684
1519
1548

I need a formula that will calculate the average number of images based on the ID on Excel 2013 if possible please?

Thanks in advance

 

[Special-K99]

Try

in Sheet2!B1
=AVERAGEIF(Sheet1!A$1:A$12,E1,Sheet1!C$1:C$12)

 

[ljnorton]

Try

in Sheet2!B1
=AVERAGEIF(Sheet1!A$1:A$12,E1,Sheet1!C$1:C$12)

Worked Great! Thanks for the quick response.