Guys,
Please can I have your assistance, =sumifs is returning #value as the workbook it's linked too is closed, I have read you can use sumproduct as an alternative but I don't understand it, here is my original formula
=IF(SUMIFS('G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$L:$L,'G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$B:$B,$B448,'G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$Z:$Z,$A$446)=0,0,SUMIFS('G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$L:$L,'G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$B:$B,$B448,'G:\GENERAL\Warehouse Team Files\2015\Performance\[Chill Receipts.xlsx]Week 1'!$Z:$Z,$A$446))
Can anyone convert the above to a sumproduct?
Many thanks
James
Bookmarks