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!

Hi All,

Much thanks to someone out there who can help me to solve this issue.

I am really struggling.

Hi Roy,

This is the issue I have mentioned in a wrong thread earlier.

Kindly help me to sort this out.

Much thanks!

HELLO,

Someone out there who could help me!!!!

Much thanks!!

Is there no one who can help me please!!!!!