Hi,
I have a challenge of creating a weighted average with multiple criteria. I have data that is similar to this.
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
I need to find the weighted average of Sales based on quantity but where a certain combination of criteria is defined. I need the weighted Average of PN 1234 in the USA region in the LA location.
I know how to do this with one criteria but not multiple. Sumproduct formulas are not my strong suit.
thanks!!
I have a challenge of creating a weighted average with multiple criteria. I have data that is similar to this.
Region | Location | PN | Qty | Sales |
USA | Dallas | 1234 | 1 | 100 |
USA | Dallas | 5678 | 100 | 10000 |
USA | NY | 1234 | 100 | 10000 |
USA | LA | 1234 | 10 | 100 |
USA | LA | 1234 | 100 | 10000 |
USA | NY | 5678 | 10 | 1000 |
UK | England | 1234 | 2 | 200 |
UK | Ireland | 5678 | 200 | 20000 |
UK | Ireland | 1234 | 200 | 20000 |
UK | Ireland | 1234 | 20 | 2000 |
UK | Scotland | 1234 | 200 | 20000 |
UK | Scotland | 5678 | 20 | 2000 |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
I need to find the weighted average of Sales based on quantity but where a certain combination of criteria is defined. I need the weighted Average of PN 1234 in the USA region in the LA location.
I know how to do this with one criteria but not multiple. Sumproduct formulas are not my strong suit.
thanks!!