Formula to count "blank" learners with reference to other cells

[LisaCol]

I have currently got a table that refers to a data spreadsheet to count learners, I have got the formula set up when a column contains Green, Amber or Red but I can't figure out what the formula should be if the column is blank.

The formula I currently have in J9 is:=COUNTIFS(Learners!$K:$K,Summary!I$8,Learners!$T:$T,Summary!$B9,Learners!$A:$A,">=2018-2019",Learners!$AY:$AY,Summary!$B$5), where Summary is the spreadsheet below and Learners is the spreadsheet with the data.

​

	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5		Supply Chain
6
7
8		Course	Live	Comp	Leaver	Blank	Green	Amber	Red	Blank
9		Level 2 Ware

<tbody>
</tbody>

​

 

[LisaCol]

	A	B	K	T	AX	AY
1			RED
2			RED
3			RED	Level 2 Ware
4	2018		RED	Level 2 Ware		Supply Chain
5	2018	xxxx	xxxx	Level 2 Ware		Supply Chain
6	2019		xxxx	Level 2 Ware		Supply Chain
7			RED	Level 2 Ware
8			RED	Level 2 Ware
9			RED
10			RED

<thead style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</thead><tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</tbody>

It is basically correct, but the blank is in K not in B as above, so I want to count the ones that are red in K in the summary (I9) and the ones that are blank in K in the summary (J9)