怎么用excel函数在别一个工作表里计算出每个单品每日的销售量?

2024-10-30 11:02:09
推荐回答(2个)
回答1:

=SUMIFS(Sheet1!D:D,Sheet1!A:A,"<2011-2-1",Sheet1!B:B,Sheet2!A2)-SUMIFS(Sheet1!D:D,Sheet1!A:A,"<2010-12-31",Sheet1!B:B,Sheet2!A2)
其实就是前面的小于月尾,后面的取月首时间

回答2:

用VLOOKUP函数