I have it working with =IF(B2="Period 01",SUM(F6),IF(B2="Period 02",SUM(F6,I6),IF(B2="Period 03", SUM(F6,I6,L6))))