Return Value from 2 Criteria ( Date and Symbol) from another sheet to Table of Horizontal(date) and Vertical(Symbol) format!

[RohitJung]

How to Return Value from 2 Criteria ( Date and Symbol) from another sheet to Table of Horizontal(date) and Vertical(Symbol) format!

Book1
	A	B	C	D	E	F	G	H	I
1	Date	Symbol	Price			7/1/2021	7/2/2021	7/3/2021	Date Continues
2	7/1/2021	ABD	365		UJG
3	7/1/2021	AEW	856		ABD
4	7/1/2021	FGH	356		FGH
5	7/1/2021	SE	945
6	7/1/2021	UJG	25		This solution is in another sheet
7	7/1/2021	CS	658
8	7/2/2021	MKH	326
9	7/2/2021	ABD	753
10	7/2/2021	AEW	159
11	7/2/2021	FGH	369
12	7/2/2021	SE	258
13	7/2/2021	UJG	147
14	7/2/2021	CS	123
15	7/2/2021	MKH	654
16	7/3/2021	ABD	789
17	7/3/2021	AEW	987
18	7/3/2021	FGH	456
19	7/3/2021	SE	321
20	7/3/2021	UJG	654
21	7/3/2021	CS	25
22	7/3/2021	MKH	15
23
24	This Data Source is in one sheet
Data

 

[kevin9999]

A simple Sumifs() should give you what you want.

test.xlsx
	A	B	C	D	E	F	G	H	I
1	Date	Symbol	Price			7/01/2021	7/02/2021	7/03/2021	Date Continues
2	7/01/2021	ABD	365		UJG	25	147	654
3	7/01/2021	AEW	856		ABD	365	753	789
4	7/01/2021	FGH	356		FGH	356	369	456
5	7/01/2021	SE	945
6	7/01/2021	UJG	25		This solution is in another sheet
7	7/01/2021	CS	658
8	7/02/2021	MKH	326
9	7/02/2021	ABD	753
10	7/02/2021	AEW	159
11	7/02/2021	FGH	369
12	7/02/2021	SE	258
13	7/02/2021	UJG	147
14	7/02/2021	CS	123
15	7/02/2021	MKH	654
16	7/03/2021	ABD	789
17	7/03/2021	AEW	987
18	7/03/2021	FGH	456
19	7/03/2021	SE	321
20	7/03/2021	UJG	654
21	7/03/2021	CS	25
22	7/03/2021	MKH	15
23
24	This Data Source is in one sheet
Data

Cell Formulas
Range	Formula
F2:H4	F2	=SUMIFS($C$2:$C$22,$A$2:$A$22,F$1,$B$2:$B$22,$E2)

test.xlsx
	E	F	G	H	I
1		7/01/2021	7/02/2021	7/03/2021	Date Continues
2	UJG	25	147	654
3	ABD	365	753	789
4	FGH	356	369	456
5
6	This solution is in another sheet
Sheet2

Cell Formulas
Range	Formula
F2:H4	F2	=SUMIFS(Data!$C$2:$C$22,Data!$A$2:$A$22,F$1,Data!$B$2:$B$22,$E2)

 

[RohitJung]

Thank you so much Kevin ) This Works

 

[kevin9999]

Thank you so much Kevin ) This Works

You're welcome and thanks for the feedback ?