as0810114 发表于 2014-2-19 11:23 我公式是这样 =IF(B2="户主",SUMPRODUCT((F$2:F$12=F2)*(D$2:D$12="是")),"") 你写成这样,="户主",SU ...
使用道具 举报
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-3 14:45 , Processed in 0.357050 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.