Weighted average?

Is there a way to calculate a weighted average of two columns? One of the columns is date/Time (AC) and the other is a value(AK) which I need the average of
The difference in the time readings would be the "weight"

Thanks!

A weighted average is just

=sumproduct(values * weights) / sum(weights)

NIf you need help implementing that, post a workbook.

Originally Posted by shg

A weighted average is just

=sumproduct(values * weights) / sum(weights)

NIf you need help implementing that, post a workbook.

Thanks for the help