excel内if函数公式询问只需要把每一个的,"")这三个字符去掉,

只需要把每一个的 ,"")这三个字符去掉,保留最后一个,然后将所有函数放到一起就行了

=IF(AND($B$2="全部",$B$4="所有项目"),Sheet2!H3+Sheet2!H29+Sheet2!H55+Sheet2!H76+Sheet2!H102,IF(AND($B$2="全部",$B$4="项目一"),Sheet2!H3+Sheet2!H29,IF(AND($B$2="全部",$B$4="项目二"),Sheet2!H76+Sheet2!H102,IF(AND($B$2="全部",$B$4="项目二"),Sheet2!H55,""))))

---

=if($b$2="全部",if($b$4="所有项目",Sheet2!H3+Sheet2!H29+Sheet2!H55+Sheet2!H76+Sheet2!H102,if($b$4="项目一",Sheet2!H3+Sheet2!H29,if($b$4="项目二",Sheet2!H76+Sheet2!H102,""))),if($b$4="项目二",Sheet2!H55,"")

---