Good morning,

I'm attempting to count the # of items on a worksheet that match specific criteria using arrays. I'm using the following formula and am hoping to further simplify or keep the same length in order to arrive at the correct answer as this formula is nested within another to calculate a more complex end result. Any suggestions?

=PRODUCT(SUM(COUNTIFS(Employees!$A:$A,U1:U36,Employees!$B:$B,{"UT-4","UT-3","UT-2","UT-1"},Employees!$F:$F,{"IP";"DA";"F"},Employees!$G:$G,"Focused on CL")),0.4)

Thank you!