查看全部评分
使用道具 举报
1 =IF(AG4=AG$7,AH4+MAX(AN$3:AN3),"")2 辅助列AO23单元格输入 =LOOKUP("々",AF$23:AF23) 然后输入=SUMIF(AO23:AO44,AF23,AJ23:AJ44)3 =SUMPRODUCT((AF$49:AF$61=AJ48)*AH$49:AH$61)4 =SUM(--EXACT($AF$65:$AF$73,AJ65)) 三键5 =SUM((MONTH(AF77:AF84)=4)*AG77:AG84) 三键
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-31 15:24 , Processed in 0.603958 second(s), 5 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.