Compute Average base on different column

**ray_bt** · 05-19-2010, 04:38 AM

Hi all,

Is there any built in function to perform the task below or I need to write my own macro for that?

Name Column2 Value
A a 2
B b 3
A c 5
C d 6
C a 8
D a 9

How do I compute the average of Name column value
i.e. A = (2 + 5) / 2 = 3.5 Since Row 1 and 3 have name A and
C will be 14/2 = 7 and display onto other cell?

Please advise

**DonkeyOte** · 05-19-2010, 04:48 AM

Either use a Pivot Table or given use of XL2007 see AVERAGEIF function in XL Help

=AVERAGEIF(A:A,"A",C:C)

note above function is not backwards compatible with earlier versions - for compatibility:

=SUMIF(A:A,"A",C:C)/COUNTIF(A:A,"A")