excel如何统计某一时间段内的数据金额之和

2024-12-16 10:05:07
推荐回答(3个)
回答1:

按上公式处理

回答2:

=SUMIFS(C:C,D:D,">="&DATE(E1,F1,1),D:D,"<="&DATE(E1,F1+1,1)-1)

回答3:

=SUMIFS(C:C,B:B,">="&H1,B:B,"<="&I2)