Afternoon,

I currently have a large file... over 400 columns and over 25,000 rows... and to produce the required report from this data I am using a series of array SUMIF formulae but they are too slow.

When I make the required changes to the file the recalculation time is around 8 minutes, not good when you need to use the file within a meeting or something similiar.

I was wondering if anyone knew of a quicker and more efficient formula I would be able to use??

I am using the following formula (or a variation of) at the moment: 

{=SUM(IF(Data!$EF$3:$EF$29999>=39934,IF(Data!$EF$3:EF$29999<=39964,Data!$EM$3:$EM$29999,0)))}
Hope you can help me...

Thanks