I am trying to copy down the formula below 201,000 rows. I can get the formula to copy down ok but it takes hours to complete and sometimes longer. I have to do this with 30 columns so I hoping to somehow speed up the calculations.

=COUNTIFS(Results!$C:$C,A3,Results!$A:$A,$H$1,Results!$B:$B,$H$2,Results!$I:$I,"L")+COUNTIFS(Results!$C:$C,B3,Results!$A:$A,H$1,Results!$B:$B,$H$2,Results!$I:$I,"L")+COUNTIFS(Results!$C:$C,C3,Results!$A:$A,H$1,Results!$B:$B,$H$2,Results!$I:$I,"L")+COUNTIFS(Results!$C:$C,D3,Results!$A:$A,H$1,Results!$B:$B,$H$2,Results!$I:$I,"L")+COUNTIFS(Results!$C:$C,E3,Results!$A:$A,H$1,Results!$B:$B,$H$2,Results!$I:$I,"L")

Office 2007




Marc Four