上官婉婷 发表于 2021-12-17 22:58:42

感谢至极！

邱蓬 发表于 2021-12-19 10:24:06

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

京山八一路手机通讯 发表于 2021-12-19 21:03:34

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

口合哈大笑 发表于 2021-12-22 17:36:26

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

韦伟 发表于 2021-12-29 06:17:33

=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-1-3 11:11:35

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

一辈子的顾南笙 发表于 2022-1-6 15:13:06

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

闲人大叔 发表于 2022-1-7 06:16:44

感谢至极！

无心丶 发表于 2022-1-8 07:04:12

感谢至极！

陆春宇 发表于 2022-1-12 20:14:27

=SUM(OFFSET($C$3,MATCH(DATE(2021,11,18),$B$4:$B$19,),,-3))/3
页: 1 [2] 3
查看完整版本: 求前三天日均值