关于 求和横向条件！

刘天意爸爸

如文件和图片！希望大神教一下小弟，万分感谢！

求助.zip (8.9 KB, 下载次数: 77)

2021-11-12 13:58 上传

点击文件名下载附件
求助.zip

晏晓飛

=SUMIF($C$3:$J$3,"<>"&"打包*",C4:J4)小计1下拉

長月北見

=SUMIF($C$3:$J$3,"打包*",C4:J4)小计2下拉

金雁南飞

K4:
=SUMIF($C$3:$J$3,"<>打包*",$C4:$J4)
L4:
=SUMIF($C$3:$J$3,"打包*",$C4:$J4)

星莱

这样？
K4=IF(K$3="小计1",SUMIF($C$3:$J$3,"<>"&"打包*",$C4:$J4),SUMIF($C$3:$J$3,"打包*",$C4:$J4))右拉下拉

藿香正气

K4=SUM(C4:G4)
L4=SUM(H4:J4)