Hi guys,
I would like to calculate a weighted average using sumproduct. The issue is the databases I am pulling from are asymmetrical. Essentially what I want to do is do an index/match that returns an array (1 row of data) which is based off of two criteria, location and date. I already know how to perform a 2 criteria index/match using &, but I am not sure how to make the return of the index/match be an array versus a single cell.
I have attached a simplified version of my data. My actual data has hundreds of rows so the formula is not trivial.
Thanks in advance!
David
Bookmarks