Sum range with subtracting two columns

[italy16]

Col A	B	C	D	D	E
Row 1				Nov 18	Dec 18
2	New	R	Customer	45	57
3	Old	R	Customer	45	89
4	Ok	NF	Customer	24	89
5	Ok	NF	Customer	12	98

<tbody>
</tbody>

Hello - I'm trying to "Sum" the different b/w Col.'s E and D IF column B is equal to either "new" "old" "Ok" AND Col C is equal to "R" or "NF"

So for row 4, it would be if B is equal to OK and Col C is equal to NF, then take the difference b/w Col E and D (which is 86)

Thank you in advance

 

[jtakw]

Hi,

Assuming you meant Row 5, not Row 4, having the result of 86, and the extra Column D "Customer" is meaningless for this query:

Excel 2010
	A	B	C	D	E	F	G
1	Row 1			18-Nov	18-Dec
2	2	New	R	45	57		12
3	3	Old	R	45	89		44
4	4	Ok	NF	24	89		65
5	5	Ok	NF	12	98		86
Sheet6

Cell Formulas
Range	Formula
G2	=IF(AND(OR(B2={"New","Old","Ok"}),OR(C2={"R","NF"})),E2-D2,"")

G2 formula copied down.

 

[markmzz]

Col A	B	C	D	D	E
Row 1				Nov 18	Dec 18
2	New	R	Customer	45	57
3	Old	R	Customer	45	89
4	Ok	NF	Customer	24	89
5	Ok	NF	Customer	12	98

<tbody>
</tbody>

Hello - I'm trying to "Sum" the different b/w Col.'s E and D IF column B is equal to either "new" "old" "Ok" AND Col C is equal to "R" or "NF"

So for row 4, it would be if B is equal to OK and Col C is equal to NF, then take the difference b/w Col E and D (which is 86)

Thank you in advance

Maybe this:

=SUMPRODUCT(F2:F5-E2:E5,--(MMULT(--ISNUMBER(SEARCH(" "&B2:C5&" "," New Old Ok R NF ")),{1;1})=2))

Markmzz