Alright, apparently I am not understanding. This time I am needing to sumif checkmarks in each row and add the amount at the bottom if true. I butchered this formula...I am not understanding the r:c separation for some reason. It looks easy, until I try it.



ActiveCell.FormulaR1C1 = _
        "=SUMIF(RINDEX(R,COLUMN()-1):C5),""ü"",RINDEX(R[-2],COLUMN()-1):C5)"