#NUM! Error with Extracting Data Based on Criteria

Originally Posted by Søren Larsen

I took a look at your workbook, but I find it difficult to give any suggestions as long as you have all these ref/num errors. Do you have a working workbook we could see?

Yes, but as it is to be a commercial product, I don't wish to put the whole of the workbook on here (it is also 42MB in size). What I can do though is find another means of sending it to you.