Speeding up SUMPRODUCT/ SUMIFS array formula

Hi all,

I have a large data set where I need to SUM cells IF a certain criteria is met without using helper columns. The formula I am currently using is giving the right results, though, as it is a SUMPRODUCT/ SUMIFS array formula it makes the file unnecessarily slow. I have already speeded it up by using:

=IF(G$3=0,0

at the beginning of the formula to not have it calculate the array if not relevant, this speeds it up by about a factor of 2 in my data set.

=IF(G$3=0,0,IFERROR(SUMPRODUCT(--(ISNUMBER(G$7:G$409)+ISNUMBER(SEARCH(SUBSTITUTE(G$7:G$409," ",""),REPT("x",3)))>0),--(G$7:G$409>0),--(Attribute_Drop<>"DROP"),--(Attribute_Status<>"INACTIVE"),SUMIFS(INDEX(IA!$A:$ZZ,0,G$1),IA!$A:$A,"JAPAN",IA!$C:$C,Attribute_PricePoint,IA!$B:$B,Attribute_RetailClass)),0))

Now I was wondering if there is another "trick" to make it ignore calculations if not relevant. E.g. Only SUMIF data from the "IA" sheet if criteria is met and "skip" calculation of cells in the array that aren't relevant. Currently even if ALL data in the GREY cells is deleted, calculation times don't change!! The formula still seems to run through every single cell in the array and calculate the SUM of all PRODUCTS. Is it possible to rewrite the formula somehow so that it skips these cells? Or use a different approach/formula altogether?

BTW I am currently testing the speed with a macro. Select the cells that need testing and press CONTROL+SHIFT+R. It gives me about 0.17 seconds for all "MIN IA" cells (29 cells in total). In my data set it's about 10 seconds as the array gets longer.