Hi All, Could you please kindly advise as to why the below formula throws a run time error (1004) on the 'RC' part, when I try to run it inside of a previously working loop?

.Cells(NextRow, "J").Value = "=SUMIFS($J:$J,$C:$C,RC[-7],$G:$G,""TEST*"")"
I'm trying to input a relative reference to Col C from Col J, for what it's worth.

Many thanks!