sumif和countif,不过需要连续的单元格，你说的随机选几个表格，貌似难以实现。=sumif(D2:P2,">0")/countif(D2:P2,">0")计算从D2到P2所有表格中大于0的平均值。=average(Z2:Z3)*1.8=average(Z3:Z4)*1.8
