Count for date older than 30 days, column C AND D blank - for worker

you dont need the AND , but a range and count ifs work like this
=COUNTIFS($A2:$A1430,"<"&TODAY()-30,$A2:$A1430, "<>",$C2:$C1430,"",$D2:$D1430,"",$B2:$B1430, "EARL")
if you want the name hard coded

Quite a large dataset to provide a solution to ,also looking at all the conditional formatting rules - NOT sure why you have all the different applied to ranges and cells
you would usually select the range you want the conditional forammting to be applied to
which is A2 to G1430 and then use a formula with row 2 in
=AND($A2<TODAY()-30,$A2 <>"",$C2="",$D2="")
that will highlight the row A to G
I suspect you may have done that and then deleted and added rows which has changed the applied to range - NOT Sure

- anyway , the countifs

I have had to make some of earls data blank in C and D , made 11 rows clear
and have a count now of 12 in K3

Not sure where you want the answer
also not sure why specifiying row 1357
I have used the full rang eof rows $A2:$A1430
but may need extending if adding more data

you are welcome , glad its all worked out ok

=COUNTIFS($A2:$A1430,"<"&TODAY()-30,$A2:$A1430, "<>",$C2:$C1430,"",$D2:$D1430,"",$B2:$B1430, "EARL")

you can just extend the rows
=COUNTIFS($A2:$A10000,"<"&TODAY()-30,$A2:$A10000, "<>",$C2:$C10000,"",$D2:$D10000,"",$B2:$B10000, "EARL")

so now will use any data in rows 2 to 10,000 rows


for highlighting conditional formatting
you can change the "applied to" range

A2:G10000

so long as the starting row in the selected / applied to range - in this - 2 - matches the formula row
so it is looking at ROW 2 and the formula is also looking at row2

as it is at the moment
=AND($A2<TODAY()-30,$A2 <>"",$C2="",$D2="")

and you are testing to make sure A2 is NOT blank and so will NOT highlight the blank cells from say row
1430 to 10,000

you are welcome