Formula required please

[Zubair]

Dear Experts,

Can I have the formula in cell B14:C15 based on the headings B1:M3 and data A4:M8 Please.

Mr. Excel.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Product	Scenario 1	Scenario 1	Scenario 1	Scenario 2	Scenario 2	Scenario 2	Scenario 3	Scenario 3	Scenario 3	Scenario 4	Scenario 4	Scenario 4
2		Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1
3		DF	SF	CF	DF	SF	CF	DF	SF	CF	DF	SF	CF
4	A	1,000	1,100	1,200	1,010	1,210	900	1,020	1,111	789	1,030	1,040	1,050
5	B	111	110	123	230	140	980	333	500	800	120	145	160
6	C	889	990	1,077	780	1,070	(80)	687	611	(11)	910	895	890
7	D	100	100	100	100	100	100	100	100	100	100	100	100
8	E	789	890	977	680	970	(180)	587	511	(111)	810	795	790
9
10
11	Product	Scenario 1	Scenario 3
12		Y1	Y1
13		DF	SF
14	A
15	E
16
17
Formula

Cell Formulas
Range	Formula
B8:M8,B6:M6	B6	=B4-B5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B8:M8	Cell Value	duplicates	text	NO

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Product	Scenario 1	Scenario 1	Scenario 1	Scenario 2	Scenario 2	Scenario 2	Scenario 3	Scenario 3	Scenario 3	Scenario 4	Scenario 4	Scenario 4
2		Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1	Y1
3		DF	SF	CF	DF	SF	CF	DF	SF	CF	DF	SF	CF
4	A	1000	1100	1200	1010	1210	900	1020	1111	789	1030	1040	1050
5	B	111	110	123	230	140	980	333	500	800	120	145	160
6	C	889	990	1077	780	1070	-80	687	611	-11	910	895	890
7	D	100	100	100	100	100	100	100	100	100	100	100	100
8	E	789	890	977	680	970	-180	587	511	-111	810	795	790
9
10
11	Product	Scenario 1	Scenario 3
12		Y1	Y1
13		DF	SF
14	A	1000	1111
15	E	789	511
Sheet1

Cell Formulas
Range	Formula
B6:M6,B8:M8	B6	=B4-B5
B14:C15	B14	=SUMPRODUCT(($B$2:$M$2=B$12)*($B$3:$M$3=B$13)*($A$4:$A$8=$A14)*($B$1:$M$1=B$11)*($B$4:$M$8))

 

[Zubair]

Many thanks Sir

 

[AhoyNC]

You're welcome. Thanks for the feedback.