Formula to sum up same field values in different workbooks

  • Hi,


    I want to sum up same filed values in a workbook, for the relevant filed's row in another workbook.


    Here in attached files, Dashboard's workbook 'No of LA' column should get the sum of same week's figures in Table 3 in 'apr' sheet in M_WH1&2 workbook.


    I tried a formular but it is returning only 0 and I cannot figure out why.


    Highly appreciate the support to sort this out! :)

    Files

    • DASHBOARD.xlsx

      (11.84 kB, downloaded 100 times, last: )
    • M_WH1&2.xlsx

      (22.7 kB, downloaded 95 times, last: )