Excel Help

#1
I have been assigned the task of redoing my companies new excel sheets for 2016. On one of these sheets, the top row is tasks we performed, say a brief physical. here are anywhere between 4-25 tasks. The side row is numbered 1-31 for the days in a month. I need to assign the tasks labeled rows, a numerical value, so that when I go to the side row #1, and put in a number 2, stating that I performed 2 of these on the first, then the sheet will take that 2 and multiply it by 55 and put it in my total box.

I have been doing this formula, by hand. =SUM(B8*55+C8*65+D8*75+E8*151+F8*60+G8*25+H8*71.62+I8*57.75+J8*42+K8*20+L8*123.36+M8*78.75+N8+O8+P8*12+Q8*44.8+R8*30.9+S8*122.32+T8*34.65+U8+V8*20+W8+X8*9.9+Y8+Z8+AA8)

and then just changing the row number, but for each of the 31 days, this gets very tedious. So is there a way to just assign that "brief physical" the value of 55, so that the auto sum function will take care of it?

Someone please help me. :shakehead:shakehead:shakehead
 
#4
I need to assign each of the actions, a numerical value, so that when I place a 2 under day 6, it will take the 2 and multiply it by the value, and place it into the totals bar.
 

gianmarco

TS Contributor
#5
I need to assign each of the actions, a numerical value, so that when I place a 2 under day 6, it will take the 2 and multiply it by the value, and place it into the totals bar.
Let's assume you want to put 2 at day 6 (i.e., in the 7th row) AND in relation to "intermediate physical" (i.e., third column from the left): it is not clear to me by which value you want Excel to multiply the 2.
You were talking about assigning each action a numerical value: what does that mean?

Besides: it would make any further help easier if you attach the actual excel file.