2021-01-18 14:04:08 0.843200028
2021-01-18 14:14:27 0.843110025
2021-01-18 18:14:27 0.842890024
2021-01-18 20:14:27 0.842869997
2021-01-18 22:14:27 0.84266001
2021-01-19 00:14:27 0.842679977
2021-01-19 02:14:27 0.84246999
2021-01-19 03:42:24 0.842199981
2021-01-19 05:42:24 0.841449976
2021-01-19 07:42:24 0.841229975
2021-01-19 09:42:24 0.841199994
2021-01-19 11:42:24 0.841910005
2021-01-19 13:42:24 0.842679977
2021-01-19 15:42:24 0.842729986
2021-01-19 17:42:24 0.84206003
2021-01-19 19:42:24 0.841480017
2021-01-19 21:42:24 0.841400027
2021-01-19 23:42:24 0.841199994
2021-01-20 01:42:24 0.840820014
2021-01-20 03:42:24 0.840560019
2021-01-20 05:42:24 0.840229988
2021-01-20 07:42:24 0.839959979
2021-01-20 11:42:24 0.841109991
2021-01-20 13:42:24 0.842010021
2021-01-20 15:42:24 0.842149973
2021-01-20 17:42:24 0.841910005
2021-01-20 19:42:24 0.841530025
2021-01-20 21:42:24 0.841629982
2021-01-20 23:42:24 0.841530025
2021-01-21 01:42:24 0.84145999
2021-01-21 03:42:24 0.841549993
2021-01-21 03:57:38 0.841409981
2021-01-21 03:57:39 0.841440022
2021-01-21 05:57:39 0.841289997
2021-01-21 07:57:39 0.841009974
2021-01-21 13:57:39 0.843010008
2021-01-21 15:57:39 0.843379974
2021-01-21 17:57:39 0.842930019
2021-01-21 19:57:39 0.842450023
2021-01-21 21:44:43 0.842019975
2021-01-21 23:44:43 0.841700017
如果以上输入的日期再A列,数值在B列,那么计算2021-01-18日平均的公式为:
=SUMIFS(B:B,A:A,">=2021-01-18",B:B,"<2021-01-19")
/COUNTIFS(A:A,">=2021-01-18",B:B,"<2021-01-19")
示例如下图:
公式表示18日的合计数、除以个数。