Calculate the sum of a list of items on the day

[umirin]

Hi I'm looking for help with a formula to go into H2 and fill to H6
In the H column I've put what the formula results should calculate to.

When I put a code into F column, the H column should calculate the sum of those codes on the given day

Thanks

Book1
	A	B	C	D	E	F	G	H
1	Date	Code	Price			Calc only these Codes	Date	Total Sum for Codes on the Day
2	Tuesday, 20 April 2021	ABC	2			ABC	Tuesday, 20 April 2021	29
3	Wednesday, 21 April 2021	ABC	4			DGF	Wednesday, 21 April 2021	19
4	Thursday, 22 April 2021	ABC	5			IJK	Thursday, 22 April 2021	16
5	Friday, 23 April 2021	ABC	6				Friday, 23 April 2021	15
6	Saturday, 24 April 2021	ABC	3				Saturday, 24 April 2021	13
7	Tuesday, 20 April 2021	DGF	5
8	Wednesday, 21 April 2021	DGF	8
9	Thursday, 22 April 2021	DGF	3
10	Friday, 23 April 2021	DGF	5
11	Saturday, 24 April 2021	DGF	4
12	Tuesday, 20 April 2021	LKI	7
13	Wednesday, 21 April 2021	LKI	4
14	Thursday, 22 April 2021	LKI	2
15	Friday, 23 April 2021	LKI	7
16	Saturday, 24 April 2021	LKI	9
17	Tuesday, 20 April 2021	ZTY	1
18	Wednesday, 21 April 2021	ZTY	5
19	Thursday, 22 April 2021	ZTY	6
20	Friday, 23 April 2021	ZTY	3
21	Saturday, 24 April 2021	ZTY	6
22	Tuesday, 20 April 2021	IJK	22
23	Wednesday, 21 April 2021	IJK	7
24	Thursday, 22 April 2021	IJK	8
25	Friday, 23 April 2021	IJK	4
26	Saturday, 24 April 2021	IJK	6
Sheet1

 

[Habtest]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Date	Code	Price			Calc only these Codes	Date	Total Sum for Codes on the Day
2	4/20/2021	ABC	2			ABC	4/20/2021	29
3	4/21/2021	ABC	4			DGF	4/21/2021	19
4	4/22/2021	ABC	5			IJK	4/22/2021	16
5	4/23/2021	ABC	6				4/23/2021	15
6	4/24/2021	ABC	3				4/24/2021	13
7	4/20/2021	DGF	5
8	4/21/2021	DGF	8
9	4/22/2021	DGF	3
10	4/23/2021	DGF	5
11	4/24/2021	DGF	4
12	4/20/2021	LKI	7
13	4/21/2021	LKI	4
14	4/22/2021	LKI	2
15	4/23/2021	LKI	7
16	4/24/2021	LKI	9
17	4/20/2021	ZTY	1
18	4/21/2021	ZTY	5
19	4/22/2021	ZTY	6
20	4/23/2021	ZTY	3
21	4/24/2021	ZTY	6
22	4/20/2021	IJK	22
23	4/21/2021	IJK	7
24	4/22/2021	IJK	8
25	4/23/2021	IJK	4
26	4/24/2021	IJK	6
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=SUMPRODUCT($C$2:$C$26*($A$2:$A$26=G2)*ISNUMBER(MATCH($B$2:$B$26,$F$2:$F$4,0)))

 

[QuestionBaker]

This formula should also work, Paste it in H2 and drag it down
=SUM(SUMIFS($C:$C,$A:$A,G2,$B:$B,$F$2:$F$50))

 

[Fluff]

Another option

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1	Date	Code	Price			Calc only these Codes	Date	Total Sum for Codes on the Day
2	20/04/2021	ABC	2			ABC	20/04/2021	29
3	21/04/2021	ABC	4			DGF	21/04/2021	19
4	22/04/2021	ABC	5			IJK	22/04/2021	16
5	23/04/2021	ABC	6				23/04/2021	15
6	24/04/2021	ABC	3				24/04/2021	13
7	20/04/2021	DGF	5
8	21/04/2021	DGF	8
9	22/04/2021	DGF	3
10	23/04/2021	DGF	5
11	24/04/2021	DGF	4
12	20/04/2021	LKI	7
13	21/04/2021	LKI	4
14	22/04/2021	LKI	2
15	23/04/2021	LKI	7
16	24/04/2021	LKI	9
17	20/04/2021	ZTY	1
18	21/04/2021	ZTY	5
19	22/04/2021	ZTY	6
20	23/04/2021	ZTY	3
21	24/04/2021	ZTY	6
22	20/04/2021	IJK	22
23	21/04/2021	IJK	7
24	22/04/2021	IJK	8
25	23/04/2021	IJK	4
26	24/04/2021	IJK	6
Main

Cell Formulas
Range	Formula
H2:H6	H2	=SUM(FILTER($C$2:$C$100,(ISNUMBER(MATCH($B$2:$B$100,$F$2:$F$4,0)))*($A$2:$A$100=G2)))