如何将COUNTIFS公式转换为SUM(如果由于外部链接而避免#VALUE)

I have an Excel formula which references several cells in other files, of the format: =COUNTIFS('[FILE1.xlsx]Sheet 1'!$D:$D00,"A",'[FILE1.xlsx]Sheet 2'!$H:$H00,"B")I have an Excel formula which references severa