Hi Guys,

I'm currently using a SUMPRODUCT formula in a spreadsheet (in approx 130,000 cells) and it is slowing the calculation down immensely! I've restricted the formula to look at specific cells not full columns etc but calculation is still slow! The formula is as below:

=IF($A13>"",(SUMPRODUCT((Sheet2!$A$6:$A$506=$E13&$G13)*(Sheet2!$CW$1:$ER$1=$C13&H$12),Sheet2!$CW$6:$ER$506)),"")

Is there a faster formula that will do do the calculation that you know of?

Any help would be much appreciated!!

Thanks