求前三天日均值

吉龙哥

各位大神，帮忙啊，谢谢先！

求助前三天均值.zip (7.22 KB, 下载次数: 25)

2021-11-18 09:41 上传

点击文件名下载附件
求助前三天均值.zip

楼月

=SUM(OFFSET($C$3,MATCH(DATE(2021,11,18),$B$4:$B$19,),,-3))/3

赵誉智

=AVERAGEIFS(C4:C19,B4:B19,"<="&TODAY(),B4:B19,">="&TODAY()-2)

若能不甜不淡而不腻

数组函数
C2=AVERAGE(IF((B4:B19>TODAY()-3)*(B4:B19<=TODAY()),C4:C19,))

撒克

=SUMPRODUCT(($B$4:$B$19>(TODAY()-3))*($B$4:$B$19<=TODAY())*($C$4:$C$19))/3
=SUMIFS($C$4:$C$19,$B$4:$B$19,">"&(TODAY()-3),$B$4:$B$19,"<="&TODAY())/3

用户难忘

=AVERAGE(OFFSET(C3,MATCH(TODAY(),B4:B19),,-3))

婉玉

=SUM(SUMIF(B:B,TODAY()-{0,1,2},C:C))/3

合家乐

感谢至极！

人类就是人累

感谢至极！

舌尖上的範记

感谢至极！