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! :)


    • DASHBOARD.xlsx

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

      (22.7 kB, downloaded 95 times, last: )