=SUMIF($C:$C,$C$4,D:D) The criteria in this formula always needs to reference the cell "ActiveCell.Offset(-1, -1)". Is there a way to do this through VBA? SUMIF(C3,R4C3,C) This is what is looks like on VBA. Thanks