使用道具 举报
wgavin 发表于 2017-9-28 13:14 删除汇总行,等于啥都没做啊!!
wgavin 发表于 2017-12-2 10:37 =SUM(OFFSET(B5,,,IFERROR(MATCH(A4,A5:A500,)-1,500)))
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-3 01:07 , Processed in 0.498401 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.