4558| 24
|
[习题] [201401函初班]第二讲作业D组上交贴【已开帖】 |
发表于 2014-3-17 09:28
|
显示全部楼层
点评
=SUMIFS(E22:E30,D22:D30,"古奇",C22:C30,"<=2012-12-31",C22:C30,">2011-12-31")
评分 | ||
发表于 2014-3-17 09:30
|
显示全部楼层
评分 | ||
发表于 2014-3-17 09:34
|
显示全部楼层
点评
=SUMIFS(E22:E30,C22:C30,">=2012/1/1",C22:C30,"<2013/1/1",D22:D30,"古奇")
评分 | ||
发表于 2014-3-17 09:58
|
显示全部楼层
| |
发表于 2014-3-17 10:29
|
显示全部楼层
点评
=SUMIFS(E21:E30,D21:D30,"古奇",C21:C30,">=2012/1/1",C21:C30,"<=2012/12/31")
评分 | ||
发表于 2014-3-17 10:59
|
显示全部楼层
评分
| ||||||||||||||
发表于 2014-3-17 13:15
|
显示全部楼层
评分 | ||
发表于 2014-3-17 13:51
|
显示全部楼层
| |
发表于 2014-3-17 19:14
|
显示全部楼层
| |