I need assistance putting together a formula in a separate column that will give me the total average retainer for each client based upon the number of months below. Since there are duplicate months i cannot simply do an average. Tried doing an average if formula but need to embed something that eliminates the duplicates. For example, Client be average should be 1000 (3000 / 3 months)
Thank you in advance
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>`
Thank you in advance
Client | Team | Month | Revenue |
Client A | Team A | June | 500 |
Client A | Team B | July | 100 |
Client A | Team A | July | 500 |
Client A | Team B | August | 500 |
Client A | Team A | August | 100 |
Client A | Team B | September | 500 |
Client A | Team A | September | 100 |
Client A | Team B | October | 500 |
Client A | Team A | October | 100 |
Client B | Team B | January | 800 |
Client B | Team A | January | 200 |
Client B | Team B | February | 800 |
Client B | Team A | February | 200 |
Client B | Team B | March | 800 |
Client B | Team A | March | 200 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>