Not sure if this simplified view makes sense:
=SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array5)
)
/
SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array4)
)
Looks like your Arrays 1,2 & 3 have the common 'selection' logic across the two
functions. The difference applies to (Array5)/(Array4).
Which translates to:
=SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array5)/(Array4)
)