Letters represent numbers/ add those numbers to a cell?

[FLSPEC]

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.

	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>

 

[FLSPEC]

is there a way to add files? i can share the spreadhseet and you can see what im trying to do

 

[FLSPEC]

anyone?

 

[AliGW]

Only if you add a link to a file-sharing site, but be aware that some members cannot or will not access them.

 

[Marcílio_Lobão]

FLSPEC, Good afternoon.

Maybe I'm missing something about your explanation.

WHY (B2 + C2) Formula?
Would not that be another formula? (B2 * C2)

You mentioned material cost but no column appears with this COST.

Suppose:
C = Coatings -------->10
O = Office ----------> 20
T = Travel/Training --> 30

	A	B	C	D	E	F
1	Project	Type	Man Hours	MAN COST	MATERIAL	Project Cost
2	F350	C	30	Formula	11	(D2 + E2)
3	Marketing	O	2		22	(D3 + E3)
4	Trainging	T	6		33	(D4 + E4)

<tbody>
</tbody>

Formula:
E2 --> =CHOOSE(MATCH(B2,{"C","O","T"},0),10,20,30) * C2
Drag this formula down

This formula is useful if you have only a few type choices.

Either way the best and most professional option would be to create a type and indicator table to be able to query using the VLOOKUP function.

Please, tell us if is it what you want or I'm lost in your explanation.
I hope it helps.

 

[FLSPEC]

yes this is the table i am trying to create. Thank you ..
and yes it would be "*" not +.

works great thank you !.. for rows that do not have information in them yet, how to keep them from throwing the #N/A on those rows

FLSPEC, Good afternoon.

Maybe I'm missing something about your explanation.

WHY (B2 + C2) Formula?
Would not that be another formula? (B2 * C2)

You mentioned material cost but no column appears with this COST.

Suppose:
C = Coatings -------->10
O = Office ----------> 20
T = Travel/Training --> 30

	A	B	C	D	E	F
1	Project	Type	Man Hours	MAN COST	MATERIAL	Project Cost
2	F350	C	30	Formula	11	(D2 + E2)
3	Marketing	O	2		22	(D3 + E3)
4	Trainging	T	6		33	(D4 + E4)

<tbody>
</tbody>

Formula:
E2 --> =CHOOSE(MATCH(B2,{"C","O","T"},0),10,20,30) * C2
Drag this formula down

This formula is useful if you have only a few type choices.

Either way the best and most professional option would be to create a type and indicator table to be able to query using the VLOOKUP function.

Please, tell us if is it what you want or I'm lost in your explanation.
I hope it helps.

 

[Marcílio_Lobão]

FLSPEC, Good afternoon.

To avoid this type of error do:

E2 --> =IFERROR (CHOOSE(MATCH(B2,{"C","O","T"},0),10,20,30)*C2, "")

F2 --> =IFERROR (D2 + E2, "")

Glad to have helped.