Hello!

I have an array which is doing exactly what I need but it is also drastically slowing my workbook. I'm hoping someone may have an alternative solution which would not hinder calculations.

{=SUM(IF(Circuits!$B:$B="Fiscal '09",IF(Circuits!$A:$A=$A$2,Circuits!BX:BX,0),0))}

I have tried to make an absolute reference to Circuits!$B3:$B$283 & Circuits!$BX$3:$BX$283 but for whatever reason, the formula ceases to function properly.

Many Thanks in Advance!