問題已解決
sum ifs函數(shù)第一個(gè)數(shù)字能求出來,后面的數(shù)字往后拉為0
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師
金牌答疑老師
職稱:注冊(cè)會(huì)計(jì)師,高級(jí)會(huì)計(jì)師,律師從業(yè)資格,稅務(wù)師,中級(jí)經(jīng)濟(jì)師
您好,我們沒有把區(qū)間固定,選中區(qū)間按F4固定
2024 08/14 11:29
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785032 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 08/14 11:34
只能輸出兩個(gè)數(shù)字
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785032 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 08/14 11:34
后面的依然為0
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 08/14 11:39
您好,能把您的表格了扣扣郵箱? 401566729? 我來檢查一下行么
![](/wenda/img/newWd/sysp_btn_eye.png)