Master formula sheet works but is giving #NUM for data worksheet

I used a master document whilst setting up the worksheet ready to transfer the relevant data in and now I try and do this and have copied the formula into the relevant cells I am consistantly getting the error message.

I am unsure what the cause is even when evaluating the formula as the EXcel datacode is displayed. I am wondering if it is the array that I have used and amended for each data set, or if now I am not graphing the data (I don't need them) the formula itself required the graphs (I believe this to be highly unlikely).

I have attached my data and master sheet for people to try and help.

I am aware in the first data set rows 3:9 I have an error in cell E3 as the graph starts within the specified range but that is another issue for another post, howver the other 5 where I have entered the formula should all be returning values.

Thanks in advance

Gav

Thanks Kaper

This works for the first set but when I copy down through the other data sets gives me an #NA I have found that by entering the 1:1 for each serial Number it works. Is there any way to copy this down so it works all the way. I assume that using the $1:$1 will only give me the earliest date?