Would you be okay with adding "Total" in D1 and use "=IF(A2="","",C2*A2)" and put "=SUM(D2:D17)" in D19? It isn't simplifying the formula, but it does simplify what you want done.