求前三天日均值

绍安

=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

希腊

感谢至极！

静美出尘

感谢至极！

袁平

感谢至极！