Weighted Average with Two Weighting Criteria

[NYMerc]

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

[TABLE="width: 303"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Date of Sale[/TD]
[TD]Distance[/TD]
[TD]Pricing[/TD]
[/TR]
[TR]
[TD]11/6/2017[/TD]
[TD]0.12[/TD]
[TD]654.36[/TD]
[/TR]
[TR]
[TD]7/11/2018[/TD]
[TD]0.21[/TD]
[TD]765.31[/TD]
[/TR]
[TR]
[TD]12/19/2017[/TD]
[TD]0.32[/TD]
[TD]695.58[/TD]
[/TR]
[TR]
[TD]8/9/2018[/TD]
[TD]0.53[/TD]
[TD]858.16[/TD]
[/TR]
[TR]
[TD]8/9/2018[/TD]
[TD]0.53[/TD]
[TD]777.70[/TD]
[/TR]
[TR]
[TD]4/25/2018[/TD]
[TD]0.57[/TD]
[TD]809.44[/TD]
[/TR]
[TR]
[TD]8/29/2018[/TD]
[TD]0.58[/TD]
[TD]942.01[/TD]
[/TR]
[TR]
[TD]11/28/2017[/TD]
[TD]0.61[/TD]
[TD]736.94[/TD]
[/TR]
[TR]
[TD]2/15/2018[/TD]
[TD]0.63[/TD]
[TD]930.54[/TD]
[/TR]
[TR]
[TD]9/26/2018[/TD]
[TD]0.76[/TD]
[TD]722.15[/TD]
[/TR]
[TR]
[TD]1/24/2018[/TD]
[TD]0.9[/TD]
[TD]759.44[/TD]
[/TR]
</tbody>[/TABLE]

How would I accomplish this - I tried using the Sumproduct over Sum method, but I think I am doing it wrong...

 

[actjfc]

NYMerc,

I do not get the logic of using the date as a weight.

Anyways, if you use the serial number of the date, an array formula will find the value:

=SUM(A2:A12*B2:B12*C2:C12)/SUM(A2:A12*B2:B12)

I assumed 11/6/2017 is in the cell A2.. and so on.

Copy and paste the above formula in any empty cell, after you must hit Ctrl Alt Enter simultaneusly, then the formula will show as

{=SUM(A2:A12*B2:B12*C2:C12)/SUM(A2:A12*B2:B12)} the result is 799.48.

It will not work if the {} are manually entered. If you press only Enter, you will get #Value !

I hope it helps!