已知:B列日期 L列日收入金额2011-05-01 60 2011-05-02 60 2011-05-03 0 2011-05-04 0 2011-05-04 0 2011-05-05 0 2011-05-06 0 2011-05-07 65 2011-05-08 50 2011-05-09 70 2011-05-10 45 2011-05-11 220 2011-05-11 50 2011-05-13 60 2011-05-13 65 2011-
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 22:21:38
![已知:B列日期 L列日收入金额2011-05-01 60 2011-05-02 60 2011-05-03 0 2011-05-04 0 2011-05-04 0 2011-05-05 0 2011-05-06 0 2011-05-07 65 2011-05-08 50 2011-05-09 70 2011-05-10 45 2011-05-11 220 2011-05-11 50 2011-05-13 60 2011-05-13 65 2011-](/uploads/image/z/13708570-58-0.jpg?t=%E5%B7%B2%E7%9F%A5%EF%BC%9AB%E5%88%97%E6%97%A5%E6%9C%9F+L%E5%88%97%E6%97%A5%E6%94%B6%E5%85%A5%E9%87%91%E9%A2%9D2011-05-01+60+2011-05-02+60+2011-05-03+0+2011-05-04+0+2011-05-04+0+2011-05-05+0+2011-05-06+0+2011-05-07+65+2011-05-08+50+2011-05-09+70+2011-05-10+45+2011-05-11+220+2011-05-11+50+2011-05-13+60+2011-05-13+65+2011-)
已知:B列日期 L列日收入金额2011-05-01 60 2011-05-02 60 2011-05-03 0 2011-05-04 0 2011-05-04 0 2011-05-05 0 2011-05-06 0 2011-05-07 65 2011-05-08 50 2011-05-09 70 2011-05-10 45 2011-05-11 220 2011-05-11 50 2011-05-13 60 2011-05-13 65 2011-
已知:
B列日期 L列日收入金额
2011-05-01 60
2011-05-02 60
2011-05-03 0
2011-05-04 0
2011-05-04 0
2011-05-05 0
2011-05-06 0
2011-05-07 65
2011-05-08 50
2011-05-09 70
2011-05-10 45
2011-05-11 220
2011-05-11 50
2011-05-13 60
2011-05-13 65
2011-05-14 60
2011-05-14 80
2011-05-16 70
2011-05-22 45
2011-05-24 45
2011-05-25 30
2011-05-26 10
2011-05-26 30
2011-05-27 220
2011-05-28 45
2011-05-29 80
2011-05-29 120
2011-05-31 180
请问excel怎样计算月平均收入?未出现的天数和收入为0的天数也要算一天
已知:B列日期 L列日收入金额2011-05-01 60 2011-05-02 60 2011-05-03 0 2011-05-04 0 2011-05-04 0 2011-05-05 0 2011-05-06 0 2011-05-07 65 2011-05-08 50 2011-05-09 70 2011-05-10 45 2011-05-11 220 2011-05-11 50 2011-05-13 60 2011-05-13 65 2011-
=sum(B:B)/31