=IF((SUMIF($C$4:$G$4,\'\'一\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'二\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'三\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'四\'\',C7:G7)sumif($C$4:$G$4,\'\'五\'\',C7:G7))=0,\'\'\'\',(SUMIF($C$4:$G$4,\'\'一\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'二\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'三\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'四\'\',C7:G7)+SUMIF($C$4:$G$4,\'\'五\'\',C7:G7)))老師你幫我看下這個(gè)函數(shù)有問題嗎,一提交就說公式錯(cuò)誤
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/012/94/14/14_avatar_middle.jpg?t=1651217117)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](https://pic1.acc5.cn/012/94/14/14_avatar_middle.jpg?t=1651217117)
![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/img/newWd/sysp_btn_eye.png)