How to sum an array, after applying a few conditions to it? It's complicated, I'm attaching a file.

Detlef_Lewin 

My argument would be "do you need to see the value?", "why is it important to you?"  If there is no reason to see the intermediate values, then they merely constitute 'sheet junk', in much the same manner as extraneous ornamentation of charts is described a 'chart junk'.

Despite that, there are reasons of computational efficiency that might justify creating an array of intermediate results.  Also, many users like to be able to check Excel calculations with a pocket calculator. For me, that is mis-directed effort.  They would be better advised to create readable formulas and check those, because errors are (virtually) always to be found in the users' code, not the Excel evaluation.