Count text formula based on multi-criteria excluding duplicates

Hi,

So, I have a solution with an array formula where i can retrieve text based values that exclude duplicates with multiple criteria. How ever, I dump about 5,000 rows of data each week, and the array formula is so slow, and takes around 15 mins to update. I used to used a pivot table, but that wasn't 'automated' either.

You can find my solution in R2:R8 which is the unique value that I want to retrieve from L:L.

In the table in T2, I want to do a COUNTIFS based on the values in T:T and U1:AF1.

Is there any way I can solve this without an array formula?