求前三天日均值

上官婉婷

感谢至极！

邱蓬

=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

闲人大叔

感谢至极！

无心丶

感谢至极！

陆春宇

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