Hi, I found a filtered weighted average formula on a different excel forum that seems to have worked with data. Here's the formula that I have inputted into my excel sheet: =SUMPRODUCT(SUBTOTAL(3,OFFSET(Z12:Z1548,ROW(Z12:Z1548)-ROW(Z12),,1)),Z12:Z1548,U12:U1548)/SUBTOTAL(9,U12:U1548)
I don't fully understand the formula and am hoping someone could explain it to me. Much appreciated!
Bookmarks