My client has defined a mass average as SUMPRODUCT(,) / SUM() over a lookback period. This is actually a highly used algorithm in the mining industry.
I am trying to replicate the SUMPRODUCT functionality from excel. Has anyone already done this? Or a SUM() over a lookback period - similar to a moving average but using sums instead.