On the Year worksheet, enter a $3-$D SUM function in cell C$5$ to calculate the total items sold in Q$1$:Q$4.$ Using the Fill Handle, copy the formula through cell range C$6$:C$19.$ On the Auto Fill Options, choose Fill Without Formatting. With the range still selected, copy the formula through cell range C$5$:G$19.$