Count if unique value + empty cell with four criteria

[Jescanilla]

Good afternoon. as the title said im trying to count if unique values and even empty cells with for different criteria such as year, week and so on, i was trying to use
=SUM(IF(FREQUENCY(IF(LEN($J:$J)>0;MATCH($J:$J;$J:$J;0);"");IF(LEN($J:$J)>0;MATCH($J:$J;$J:$J;0);""))>0;1))
but i couldn't manage to add the criteria's, i paste an example sheet of the result that i must have (but i did it manual just for explanation purposes). Please help me add criteria on that formula or build a better one.

Libro KPI mantenimiento (version 3).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
5	year	week	truck	type	ID
6	1	3	605	mc	asdasd
7	1	3	605	mc	123
8	1	3	605	mc	456mc67		year	week	truck	type	sum
9	1	3	605	mc	456mc67		1	3	605	mc	5	6
10	1	3	605	mc	456mc67		2	4	605	mc	2
11	1	3	605	mc
12	1	3	605	mc	asd
13	1	3	605	mc	asd
14	2	4	605	mc	asddd
15	2	4	605	mc
16	2	4	605	mp
17	2	4	605	mp
18	2	4	605	mp
19	2	4	605	mp
Sheet4

Cell Formulas
Range	Formula
L9	L9	=SUM(IF(FREQUENCY(IF(LEN($E:$E)>0,MATCH($E:$E,$E:$E,0),""),IF(LEN($E:$E)>0,MATCH($E:$E,$E:$E,0),""))>0,1))

Thanks by advance.

 

[Jescanilla]

sorry still not sure i get it
year 3 has blank ID's and all the columns the same so a count of unique is 1 - but you want 5 - so not counting as unique just blanks
BUT then
year 2 you also have 5 blanks - with all the same in otehr columns - but there you only count the blanks entry as 1 and not 5

sorry confused

in deed, cuz u are missing mc value in year 2 and its a conditional for the counting, one blank and one with id asddd

 

[etaf]

Ok, i was comparing your Year 3 to year 2 results in my reply , that you count blank 1 and Ids only once - BUT not for year 3

year 3 has blank ID's and all the columns the same so a count of unique is 1 - but you want 5 - so not counting as unique just blanks
BUT then
year 2 you also have 5 blanks - with all the same in otehr columns - but there you only count the blanks entry as 1 and not 5

Ignoring year 2 as we both seem to agree thats 2 = and i see why - 1 unique ID and a blank

why is year 3 5 and not 1 - not IDs just 5 blanks , your comment in L - where i show K11 as 1 - you say in L11 - it must be 5