IF CODE IN ROW, THEN MULTIPLY ADJACENT VALUE BY SPECIFIC COLUMN VALUE IN SAME ROW

[RSHVAG]

Apologies in advance if this isn't well worded.

The sheet below is an abridged version of a much larger document.

Essentially, I'm trying to add up all of the Hours for a specific employee code when multiplied by the value in the final column.

So, for the employee code CD, it would be ((0.1x225)+(0.2x225)+(0.25x100))

Any & all help is welcome...thanks!

Employee 1	Hours 1	Employee 2	Hours 2	ANNUAL OUTPUT
NO	0	NO	0	3
CD	0.1	TR	0.1	225
CD	0.2	TR	0.5	225
NO	0	NO	0	0
TR	0.25	CD	0.25	100
TR	2	NO	0	12
CW	2	TR	1	36

 

[rlv01]

How do you feel about helper columns?

Book4
	A	B	C	D	E	F	G	H	I	J
1	Employee 1	Hours 1	Calc1	Employee 2	Hours 2	Calc2	ANNUAL OUTPUT		Employees	Result
2									NO	0
3	NO	0	0	NO	0	0	3		CD	92.5
4	CD	0.1	22.5	TR	0.1	22.5	225		TR	220
5	CD	0.2	45	TR	0.5	112.5	225		CW	72
6	NO	0	0	NO	0	0	0
7	TR	0.25	25	CD	0.25	25	100
8	TR	2	24	NO	0	0	12
9	CW	2	72	TR	1	36	36
Sheet1

Cell Formulas
Range	Formula
J2:J5	J2	=SUMIF($A$3:$A$9,I2,$C$3:$C$9)+SUMIF($D$3:$D$9,I2,$F$3:$F$9)
C3:C9	C3	=B3*G3
F3:F9	F3	=E3*G3

 

[RSHVAG]

I feel like I should like them...! Thanks. I'll give this a whirl!

Much appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
Another option

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Employee 1	Hours 1	Employee 2	Hours 2	ANNUAL OUTPUT
2
3	NO	0	NO	0	3		CD	92.5
4	CD	0.1	TR	0.1	225		TR	220
5	CD	0.2	TR	0.5	225
6	NO	0	NO	0	0
7	TR	0.25	CD	0.25	100
8	TR	2	NO	0	12
9	CW	2	TR	1	36
Master

Cell Formulas
Range	Formula
H3:H4	H3	=SUMPRODUCT((($A$3:$A$9=G3)*($B$3:$B$9))+(($C$3:$C$9=G3)*($D$3:$D$9)),$E$3:$E$9)