Thanks for your help in advance...
I have to figure out pricing, using a weighted average. But I have two Weighting Criteria. Dates & Distance (Fractions of a Mile).
<colgroup><col><col><col></colgroup><tbody>
</tbody>
How would I accomplish this - I tried using the Sumproduct over Sum method, but I think I am doing it wrong...
I have to figure out pricing, using a weighted average. But I have two Weighting Criteria. Dates & Distance (Fractions of a Mile).
Date of Sale | Distance | Pricing |
11/6/2017 | 0.12 | 654.36 |
7/11/2018 | 0.21 | 765.31 |
12/19/2017 | 0.32 | 695.58 |
8/9/2018 | 0.53 | 858.16 |
8/9/2018 | 0.53 | 777.70 |
4/25/2018 | 0.57 | 809.44 |
8/29/2018 | 0.58 | 942.01 |
11/28/2017 | 0.61 | 736.94 |
2/15/2018 | 0.63 | 930.54 |
9/26/2018 | 0.76 | 722.15 |
1/24/2018 | 0.9 | 759.44 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
How would I accomplish this - I tried using the Sumproduct over Sum method, but I think I am doing it wrong...