Excel2007版有SUMIFS这个函数,你按步骤操作就可以了。如果不是2007版,假设A列是年级,B列是性别,C列是钱,那么三年级女生的钱数是 =SUMPRODUCT((A2:A99="三年级")*(B2:B99="女")*C2:C99)
10-05
759
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
530
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
![](https://csdnimg.cn/release/blogv2/dist/components/img/blogType.png)
太阳系是被设计出来的?
10-05
448
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
415
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
315
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
328
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
324
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
268
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
405
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
257
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
280
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
259
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
306
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
322
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
276
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
293
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-05
905
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交