EXCEl表格里*/*/*数据怎么求平均值答:在E1单元格输入以下数组公式,按Ctrl+Shift+Enter组合键结束,然后向下填充公式 =IF(SUMPRODUCT(LEN(A1:C1)-LEN(SUBSTITUTE(A1:C1,"/","")))>0,ROUND(AVERAGE(--MID(SUBSTITUTE(A1:C1,"/",REPT(" ",100)),1,100)),1)&"/"&ROUND(AVERAGE(--MID(SUBSTITUTE(A1:C1,"/",REPT(" ",100...