使用道具 举报
=SUMPRODUCT((订单!A2:A3>=A2)*(订单!A2:A3<=C2)*(订单!C2:C3=D4)*(订单!D2:D3=E4)*订单!E2:E3)
=SUMPRODUCT((入库!A2:A3>=A2)*(入库!A2:A3<=C2)*(入库!C2:C3=D4)*(入库!D2:D3=E4)*入库!E2:E3)
=F4-G4
我想用VB编程,因为数据很多,用函数运行太慢了
请各位高手,帮帮忙,在线等待中!
没办法编吗?
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-29 03:10 , Processed in 0.283909 second(s), 9 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.