Thank you. the formula worked.

I have another worksheet. In this one I want to total the up the number in column A for each different activity column. I will be adding columns so what the formula to pick up as I add. Do I use an array formula? See Attached worksheet.