Hey -
So created t following code trying to mimic this formula ** =SUMIFS(OOR_Data!$L:$L,OOR_Data!$Q:$Q,"="&FF4_FF2!J$5,OOR_Data!$H:$H,FF4_FF2!$C9)
[code] i = 6
Do While Range("C" & i) <> ""
Set MyRg1 = Sheets("OOR_Data").Range("L:L")
Set MyRg2 = Sheets("OOR_Data").Range("Q:Q")
Set MyRg3...