Need help with finding a value in a table for a horse that matches a date as well.

[AustSportingPix]

Horse	Champion Rating	Time Rating	BenchMark	Date	Current Rating	Lengths	Track	Finished	Conditions
A BIG CHANCE	46.08098448​	87.30133298​	-0.560763126​	16/03/2024​	49.30379306​	4.174159844​	Darwin	7 of 9	Firm
A BIT RACEY	45.75851373​	89.40594533​	-0.291103462​	2/03/2024​	42.22875804​	-3.932548909​	Wangaratta	7 of 13	Good
A BIT RACEY	46.36986315​	95.95069923​	0.608996358​	9/03/2024​	42.58504891​	-2.787071538​	Towong	2 of 10	Good
A BOOK OF DAYS	32.18217626​	99.63930777​	1.614708018​	15/03/2024​		20.98345782​	Pakenham	2 of 8	Good
A DEEL OF HUMOUR	49.77309718​	97.26578948​	-0.431618435​	1/03/2024​	52.10496391​	-5.826847338​	Ballina	1 of 10	Soft
A DEEL OF HUMOUR	51.24481704​	96.51630393​	0.540076932​	16/03/2024​	51.17221722​	-2.588443473​	Eagle Farm	1 of 13	Good
A DEVIL’S CHANCE	24.82081627​	83.31531379​	-0.141394129​	9/03/2024​	24.09660153​	-43.90796409​	Toowoomba	8 of 10	Good

The above table is what I'm working with.
I have a second table that has a column for every day.
So take "A Deel Of Humour".
I need a formula (I'm sure its easy) to find its "Champion Rating" for the 01/03/2024.

I'm thinking its index/match, but not so sure

 

[dermie_72]

=Sumifs(Champion Rating Column, Horse Column, Horse Name, Date Column, Date Value)

 

[AustSportingPix]

Thanks Dermie, that works great

 

[Peter_SSs]

Is it possible that in your second table a particular combination of date/horse does not appear in the main table? And if so, what result would you want?
Providing a possible alternative depending on answers to those questions.

24 03 18.xlsm
	A	B			E						K	L	M	N	O	P
1	Horse	Champion Rating			Date								Date	Horse	Champion Rating	Champion Rating
2	A BIG CHANCE	46.08098448			16/03/2024								1/03/2024	A DEEL OF HUMOUR	49.77309718	49.77309718
3	A BIT RACEY	45.75851373			2/03/2024								1/03/2024	A BIT RACEY	n/a	0
4	A BIT RACEY	46.36986315			9/03/2024
5	A BOOK OF DAYS	32.18217626			15/03/2024
6	A DEEL OF HUMOUR	49.77309718			1/03/2024
7	A DEEL OF HUMOUR	51.24481704			16/03/2024
8	A DEVIL’S CHANCE	24.82081627			9/03/2024
Rating

Cell Formulas
Range	Formula
O2:O3	O2	=FILTER(B$2:B$8,(A$2:A$8=N2)*(E$2:E$8=M2),"n/a")
P2:P3	P2	=SUMIFS(B$2:B$8, A$2:A$8, N2, E$2:E$8, M2)