I currently have the formula =SUMPRODUCT(COUNTIFS(3,OFFSET(I3,ROW(3:235)-5,))*(I3:I235="YES")), however, when I filter through the data and I only want it to count the cells that have "YES" when it is filtered, not just all the cells, I still get all cells with “YES”.