Excel统计同一天中24小时平均数,有几个条件: 大侠们麻烦了,所有财富奉...答:G2输入 =IF(IF(F2>17,SUM(IF($A$1:$A$10000=E2,$C$1:$C$10000,0))/24,ROUND(SUM(IF($A$1:$A$10000=E2,$C$1:$C$10000,0))/24,))>=35,IF(F2>17,SUM(IF($A$1:$A$10000=E2,$C$1:$C$10000,0))/24,ROUND(SUM(IF($A$1:$A$10000=E2,$C$1:$C$10000,0))/...