after some playing around.. and saving the file as a .xlsm (because I added a macro to import the csv files into a separate sheet from the X/Y Chart)
I was able to take the formula and everywhere that is says Setup!$B$6 I was able to replace with 1048576.....AVERAGEIFS must only have the blank space issue in xls format....seems to be working perfect now


thank you for the help....
now to work on some other versions of tables I need to chart.