Hi
I have a worksheet that is looking up the values of cell A4 in an external workbook, and adding together all the instances of the search. Here is the code inside one of the cells.
=SUMIF('G:\ORDER CONTROLS\ORDER SUMMARY\2018\05 May 2018\[WE 12 MAY 2018 ORDER...