jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey guys so i recorded the follwing
=ROUND(SUMPRODUCT(($AR163:$AR3161=AR944)+0,SUBTOTAL(109,OFFSET($J163:$J3161,ROW($J163:$J3161)-MIN(ROW($J163:$J3161)),0,1,1))),2)
it came out as
dng.SpecialCells(xlCellTypeVisible).FormulaR1C1 = "=ROUND(SUMPRODUCT((R[-781]C44:R[2217]C44=RC[-1])+0,SUBTOTAL(109,OFFSET(R[-781]C10:R[2217]C10,ROW(R[-781]C10:R[2217]C10)-MIN(ROW(R[-781]C10:R[2217]C10)),0,1,1))),2)"
it works for the bottom mos visible cells but there are cell in between and thats why its failing. any sugesstions?
Jordan
=ROUND(SUMPRODUCT(($AR163:$AR3161=AR944)+0,SUBTOTAL(109,OFFSET($J163:$J3161,ROW($J163:$J3161)-MIN(ROW($J163:$J3161)),0,1,1))),2)
it came out as
dng.SpecialCells(xlCellTypeVisible).FormulaR1C1 = "=ROUND(SUMPRODUCT((R[-781]C44:R[2217]C44=RC[-1])+0,SUBTOTAL(109,OFFSET(R[-781]C10:R[2217]C10,ROW(R[-781]C10:R[2217]C10)-MIN(ROW(R[-781]C10:R[2217]C10)),0,1,1))),2)"
it works for the bottom mos visible cells but there are cell in between and thats why its failing. any sugesstions?
Jordan