I was using SUMPRODUCT function in my excel. The formula gives me the result but it is impacting performance as the formula is used in a 70x210 matrix.

Formula used is as follows:


SUMPRODUCT( ($A14='Merged Tab with Home Country'!$E$2:$E$7243) * ('Merged Tab with Home Country'!$J$2:$HK$7243>= 10) * ('Merged Tab with Home Country'!$J$2:$HK$7243 <= 100) *(W$10= 'Merged Tab with Home Country'!$J$1:$HK$1) * ($A14 <> 'Merged Tab with Home Country'!$J$1:$HK$1) * ('Merged Tab with Home Country'!$D$2:$D$7243 = TRUE) * ('Merged Tab with Home Country'!$C$2:$C$7243 > 1))


Is there some faster alternative?

Thanks in advance for your help.
Regards,