使用道具 举报
我心飞翔410 发表于 2013-8-17 13:41 =SUMPRODUCT(($A$1:$A$20="1")*($B$1:$B$20=--MID(C1,2,1))*($C$1:$C$20="牛牛"))
shzbc 发表于 2013-8-17 16:07 使用公式sumproduct =SUMPRODUCT(($B$5:$B$24&$C$5:$C$24=LEFT($G2,2))*($D$5:$D$24=LEFT(H$1,2)))
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-7 21:01 , Processed in 0.270084 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.