Hello all,
Been trying to figure this out to no avail. I am trying to Average the previous 10 cell range from my INDEX,MATCH,MATCH result, my formula is:
AVERAGE(IFERROR(INDEX($C$2:$C$10,MATCH(1,INDEX(($A4=$A$2:$A$100)*($H$2=!$B$2:$B$100),0,1),0)),0), (IFERROR(INDEX($C$2:$C$7982,MATCH(1,INDEX(($A4=$A$2:$A$100)*($D$2=!B$2:$B$100),0,1),0)),0)))
My formula is only yielding the avg of the first, and last cells in the desired range, I am trying to Average all the cells of the range.
Thanks!
Been trying to figure this out to no avail. I am trying to Average the previous 10 cell range from my INDEX,MATCH,MATCH result, my formula is:
AVERAGE(IFERROR(INDEX($C$2:$C$10,MATCH(1,INDEX(($A4=$A$2:$A$100)*($H$2=!$B$2:$B$100),0,1),0)),0), (IFERROR(INDEX($C$2:$C$7982,MATCH(1,INDEX(($A4=$A$2:$A$100)*($D$2=!B$2:$B$100),0,1),0)),0)))
My formula is only yielding the avg of the first, and last cells in the desired range, I am trying to Average all the cells of the range.
Thanks!