Formula's are too slow

[dcwinter]

Hi everyone,

Does anyone have any suggestions about how to make this formula calculate quicker? Any way to do this sort of thing in VBA for example?

=COUNTIFS('Paste Data Here'!$G:$G,$B5,'Paste Data Here'!$Q:$Q,E$4,'Paste Data Here'!$B:$B,Data!$C$2)

Many Thanks for your help once again!

DC

 

[njimack]

Rather than referring to entire columns, consider using dynamic ranges - http://contextures.com/xlNames01.html#Dynamic

 

[dcwinter]

Thanks njimack, I'll give it a go.