Using Sumproduct to Find Average

[SteveC]

Tried, couldn't do it: this formula doesn't work, returns #value:

=SUMPRODUCT(--(Performance!$A$2:$A$1000=A16),AVERAGE(Performance!G2:G1000))

Thanks for your help:

Data Table followed by Output Table (need formula for output)

Sheet1
ColA ColG
Apples 5
Apples 6
Apples 7
Oranges 4
Oranges 8
Bannanas 6
Bannanas 4
Bannanas 2
Bannanas 4
Pineapples 3

Sheet 2
Output Table

ColA ColB (average of apples, oranges, etc.) -- need fomula for
this
Apples 6
Oranges 6
Bannanas 4
Pineapples 3

 

[SteveC]

=SUMPRODUCT(--(Performance!$A$2:$A$1000=A2),--(Performance!$G$2:$G$1000))/COUNTIF(Performance!$A$2:$A$1000,A2)

Thanks to Alan at another post...

 

[Biff]

Or this array formula:

=AVERAGE(IF(Performance!$A$2:$A$1000=A2,Performance!$G$2:$G$1000))

Biff