Hi, please see attached picture. I am trying to find the weighted average and median using array formula of column E based on the values in column D. Right now I am using a simple average on column E without taking into consideration the corresponding values, but am wondering if it is possible to do this based on weighted averages which I think might be using an array formula. Thank you.
Weighted Average on Columns.JPG
Bookmarks