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:
<tbody>
</tbody>
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>