Hi. I am trying to set up a spread sheet to help track man power, material cost, budget, actual man hours, and pay.
I have several different pay ranges per different type of "projects" ( if im coating is $$ , if im in office its $$).
I am trying to set up a number i can play in a column to represent what i was doing, If coatings "C" in the "A3" and have it know that was $20.00
If i was in the Office have "O" in "A3" and let excel know that 0 = "$17.50".
Want this to be in a single cell aswell as to be copied in to a column possibly.
When that is done I am trying to get a =SUM of that column i speak of above to add to my man hours column.
looking for B2+c2.
<tbody>
</tbody>
I have several different pay ranges per different type of "projects" ( if im coating is $$ , if im in office its $$).
I am trying to set up a number i can play in a column to represent what i was doing, If coatings "C" in the "A3" and have it know that was $20.00
If i was in the Office have "O" in "A3" and let excel know that 0 = "$17.50".
Want this to be in a single cell aswell as to be copied in to a column possibly.
When that is done I am trying to get a =SUM of that column i speak of above to add to my man hours column.
looking for B2+c2.
A | B | C | D | |
1 | Project | Type | Man Hours | Project Cost |
2 | F350 | C | 30 | (B2+C2) |
3 | Marketing | O | 2 | (B3+C3) |
4 | Trainging | T | 6 | (B4+C4) |
<tbody>
</tbody>