ActiveCell.FormulaR1C1 = _
"=SUMIF(C[-3],""Assigned"",C[-2])""In Development"",C[-2])""In Retest Prod"",C[-2])?SUMIF(C[-3],""In Retest Test"",C[-2])&SUMIF(C[-3],""Open"",C[-2])&SUMIF(C[-3],""Production Ready"",C[-2])""Ready for Production"" "
danke, daniel