SUMIFS - #VALUE error with linked workbooks on Onedrive

Hi all   I am hosting some Excel documents on Onedrive. One workbook includes a number of SUMIFS formulas referenced to the second workbook.   I am getting a #VALUE error on all of these formulas...