I am attempting to sum if the blank cells from another workbook across sheets 1 through 10 when column A:A (below) matches matches column F:F (other workbook) and row B:B (below) matches E17 (other file).
I could sumif one column at a time, and change the sheet reference manually, but there are...