# Excel Help

#### kimmie360

##### New Member
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?

#### gianmarco

##### TS Contributor
Hello,
a sample sheet would help us to better grasp your data arrangement. The description is not so clear to me.

Gm

#### kimmie360

##### New Member
I believe I have attached it correctly.

#### kimmie360

##### New Member
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
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.