=AVERAGE(IF($G$2:$AD$2<=DAY(TODAY()),G24:AD24,""))数组同时按CTRL SHIFT 回车键，猜测你意思写的:求G2:AD2的日期<=今天日期，对应G24：AD24的平均值
输入=AVERAGEIF(G24:AK24,">0")
