使用道具 举报
用VBA来修改
val(TEXT(AV35,"yyyymmdd"))<20101220
=SUMPRODUCT((OFFSET($A$5,$AW$2,$X$3-1,,$AY$2)>AV21)*(AV21>=$B$2),OFFSET($A$4,,$X$3-1,,$AY$2))
用SUMPRODUCT多判断一个生产日期是否在上线日期后,看看能不能满足你的要求~
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-21 15:56 , Processed in 0.275671 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.