I am trying to make a sumif formula look up a value of a cell within the formula and is not working for me. I need one worksheet to reference over 250 other workbooks for specific values. The formula is always the same except the workbook name changes. The formula I have is as follows and want to have the workbook name in bold a reference to another cell as I already have a list of all the excel workbook names:
=SUM(IF(('http://mywebsite/[ReferencedWorkbook.xls]Topic List'!$N$4:$N$299="Low")*('http://mywebsite/[ReferencedWorkbook.xls]Topic List'!$J$4:$J$299="Beta 2"),1,0))
I have the list of the workbook names and would like the create the formula and drag it down. So the title in bold would look at cell A1 to find the workbook name instead of me having to manually type all that stuff in.
Thanks in advance
Bookmarks