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:

	A	B	Solution written out in plain English
1	6	34%	look at all the values in column B and average them together if column A = 6. Answer: average(B1,B3,B5)= 20.33
2	4	69%
3	6	11%
4	4	21%
5	6	16%
6	3	41%

<tbody>
</tbody>

 

[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)