问题已解决
用什么函数可以解决这个取数
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/20/54/04_avatar_middle.jpg?t=1651203228)
你好,使用countifs可以实现。
2020 11/05 13:39
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/05 14:00
要怎么输入
![](https://pic1.acc5.cn/009/20/54/04_avatar_middle.jpg?t=1651203228)
方老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 11/05 14:18
你好,如图这样就可以。
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/05 15:18
如下所示
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/05 15:19
如下所示
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/05 15:19
看得到图片吗
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/05 15:21
我是想以每一列出现的次数累计,比如浙江第一行出现了一次就是1,第四行就是2
![](https://pic1.acc5.cn/009/20/54/04_avatar_middle.jpg?t=1651203228)
方老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 11/05 15:33
这样写就可以了,如图: