Is there a solution to using the same function multiple times?

Congratulations folks.  I am hugely impressed by the pattern recognition skills and the manner in which the monster formula has been reduced.  I have not got the remotest idea what the result signifies but if it is meaningful to the OP, that's OK.

I realised I haven't used the old workhorse SUMPRODUCT for many years now, either as a SUMIFS predecessor or as an array wrapper function.  I did start on the problem this morning and got as far as

before coming to the conclusion that there was going to be no great meeting of minds ever were I to produce the results.