SUMPRODUCT help

[JoshLyman]

I'm (perhaps wrongly) assuming SUMPRODUCT is the way to achieve this, but please correct me if i'm wrong. In the Hours covered column I want to calculate how many hours have been spent on each Apprenticeship KSB, which have been logged on the 3 - OTJ LOG sheet. Each time a user logs an entry, they're asked to specify which elements they've covered by choosing from a dropdown in the KSB covered columns, and saying how many hours they spent doing so in the OTJ Hours column:

I'm trying to use the below formula to sum the OTJ Hours where the KSB they've chosen corresponds to the list on the 4 - KSB Tracker sheet, but getting an error. Thank you in advance for any help!

=SUMPRODUCT(--(OTJLog[OTJ Hours]=[@[Apprenticeship KSB]]),OTJLog[[KSB(s) covered]:[KSB(s) covered2]])

DRAFT - OTJ Log - v0.2.xlsm
	B	C	D	E	F	G
16	Activity date dd/mm/yyyy	OTJ Hours	Non-OTJ Hours	Short description of the activity e.g., assignments, online learning, practical training, lectures	KSB(s) covered	KSB(s) covered2
17		2			K5: Systems thinking, knowledge/data management, research methodologies and programme management	K2: Organisation structures; business modelling; diversity; global and horizon scanning perspectives; governance and accountability; technological and policy implications
3 - OTJ LOG

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B17	Expression	=ISBLANK($B17)=TRUE	text	YES
B17	Expression	=OR(WEEKDAY($B17)=7,WEEKDAY($B17)=1)	text	NO
C17	Cell Value	>'1 - APPRENTICE INFO'!$K$20	text	NO

Cells with Data Validation
Cell	Allow	Criteria
F17:G17	List	=Lookups!$D$2:$D$47
B17	Date	between '1 - APPRENTICE INFO'!$K$22 and 31/12/9999
C17:D17	Custom	=ISNUMBER(C17)

DRAFT - OTJ Log - v0.2.xlsm
	B	C	D	E
7	Apprenticeship KSB	Times covered	Hours covered	Notes
8	K1: How to shape organisational mission, culture and values	3	#VALUE!
9	K2: Organisation structures; business modelling; diversity; global and horizon scanning perspectives; governance and accountability; technological and policy implications	1	#VALUE!
10	K3: New market strategies, changing customer demands and trend analysis	0	#VALUE!
11	K4: Innovation; the impact of disruptive technologies (mechanisms that challenge traditional business methods and practices); drivers of change and new ways of working across infrastructure, processes, people and culture and sustainability	0	#VALUE!
12	K5: Systems thinking, knowledge/data management, research methodologies and programme management	1	#VALUE!
4 - KSB TRACKER

Cell Formulas
Range	Formula
C8:C12	C8	=COUNTIF(OTJLog[[KSB(s) covered]:[KSB(s) covered8]],[@[Apprenticeship KSB]])
D8:D12	D8	=SUMPRODUCT(--(OTJLog[OTJ Hours]=[@[Apprenticeship KSB]]),OTJLog[[KSB(s) covered]:[KSB(s) covered8]])

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C8:D53	Cell Value	>1	text	NO
C8:D53	Cell Value	=1	text	NO
C8:D53	Cell Value	<1	text	NO