绍安 发表于 2022-1-22 11:38:07

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

刘飞彪 发表于 2022-1-30 04:57:28

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

丰庆包粥道 发表于 2022-1-30 17:07:02

=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

鱼会哭吗 发表于 2022-2-2 01:25:41

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

王世春 发表于 2022-2-5 22:04:01

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

希腊 发表于 2022-2-9 22:15:55

感谢至极！

静美出尘 发表于 2022-2-17 15:19:35

感谢至极！

袁平 发表于 2022-2-25 02:54:03

感谢至极！
页: 1 2 [3]
查看完整版本: 求前三天日均值