问题已解决
帶小數(shù)點的數(shù)字 整數(shù)部分求和有什么公式?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
你好
試一下這個函數(shù)呢
=SUMPRODUCT(INT(A1:A2)*1)
2019 10/14 11:49
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785041 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 10/14 14:04
老師,四舍五入以后求和用什么公式呢
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 10/14 14:08
四舍五入?保留幾位小數(shù)?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785041 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 10/14 14:09
整數(shù)
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 10/14 14:29
試一下這個函數(shù)呢
=SUMPRODUCT(ROUND(H1:H3,0)*1)
![](/wenda/img/newWd/sysp_btn_eye.png)