吉龙哥 发表于 2021-11-18 09:41:00

求前三天日均值


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

楼月 发表于 2021-11-19 13:49:27

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

赵誉智 发表于 2021-11-25 16:04:45

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

若能不甜不淡而不腻 发表于 2021-11-29 13:28:33

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

撒克 发表于 2021-12-4 05:58:51

=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

用户难忘 发表于 2021-12-4 10:05:41

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

婉玉 发表于 2021-12-12 14:31:28

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

合家乐 发表于 2021-12-12 18:43:26

感谢至极！

人类就是人累 发表于 2021-12-16 09:27:43

感谢至极！

舌尖上的範记 发表于 2021-12-17 00:26:59

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