I thought that by using the SUMPRODUCT function, rather than Array formulas,
the calculation process would be much quicker. However, with over 5000
functions, the calculation is dreadfully slow. Since I am looking up multiple
criteria, is there a benefit of running one type (SUMPRODUCT VS ARRAY) over
another?

Sam