我有这个公式
=B46+C46-D46-SUMIFS($G$2:$G$42, $A$2:$A$42, A46, $D$2:$D$42,"?uction*", $F$2:$F$42,"n")-SUMIFS($G$2:$G$42, $A$2:$A$42, A46, $D$2:$D$42,"Attorney")
我想确保在将任何空格与字符串"Attorney"进行比较之前从第D
列中删除。有人可以告诉我如何更新这个公式吗?
未测试,但看看这是否有效
=B46+C46-D46-SUMIFS($G$2:$G$42, $A$2:$A$42, A46, $D$2:$D$42,"?uction*", $F$2:$F$42,"n")-SUMIFS($G$2:$G$42, $A$2:$A$42, A46, Arrayformula(trim($D$2:$D$42)),"Attorney")