您可以将帮助器列添加到显示检查结果的工作表2中。
这是E2中的公式

=LET(
sumSheet1, SUM(FILTER('Sheet 1'!$C$2:$D$5,('Sheet 1'!$A$2:$A$5=A2)*('Sheet 1'!$B$2:$B$5=B2))),
sumSheet2, SUM(FILTER($D$2:$D$12,($A$2:$A$12=A2)*($B$2:$B$12=B2))),
IF(sumSheet1 = sumSheet2,"OK","Total for ID = " & A2 & " and Type = " & B2 & " has to be " & sumSheet1 & " but equals to " & sumSheet2)
)

您还可以使用基于上述公式（设置为警告）的用户定义公式进行数据验证。

=LET(
sumSheet1, SUM(FILTER('Sheet 1'!$C$2:$D$5,('Sheet 1'!$A$2:$A$5=A2)*('Sheet 1'!$B$2:$B$5=B2))),
sumSheet2, SUM(FILTER($D$2:$D$12,($A$2:$A$12=A2)*($B$2:$B$12=B2))),
sumSheet1 = sumSheet2)
)

但是用户没有关于这两个和的信息...来调整这些值。