Average cells in one column if corresponds with value in another column

[danikva]

What would be the formula if I'd like to average all the cells in column B that correspond to a value in column A? Column A has a rank from 1-10 and column B has a percentage. I think it will be a sumproduct or averageifs but not sure.

Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]Solution written out in plain English
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]6
[/TD]
[TD]34%
[/TD]
[TD]look at all the values in column B and average them together if column A = 6. Answer: average(B1,B3,B5)= 20.33
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]69%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]6
[/TD]
[TD]11%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]21%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]16%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]3
[/TD]
[TD]41%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[danikva]

I don't think you can remove a post without reporting it but I solved my own problem. Thank any way.

solution: =averageif(A:A,6,B:B)