Excel如何自动统计一周的列计数总和?
上周计数
=COUNTIFS(C20:C10000,">="&TODAY()-WEEKDAY(TODAY(),2)-6,C20:C10000,"<="&TODAY()-WEEKDAY(TODAY(),2))
本周计数
=COUNTIFS(C20:C10000,">="&TODAY()-WEEKDAY(TODAY(),2)+1)
上周计数
=COUNTIFS(C20:C10000,">="&TODAY()-WEEKDAY(TODAY(),2)-6,C20:C10000,"<="&TODAY()-WEEKDAY(TODAY(),2))
本周计数
=COUNTIFS(C20:C10000,">="&TODAY()-WEEKDAY(TODAY(),2)+1)