excel 如何截取指定区域内数值后计算平均数
发布网友
发布时间：2022-04-22 10:08
共1个回答
热心网友
时间：2023-07-26 10:54
1=ROUND(AVERAGE(IF(LEFT(A1:D10)="L",--SUBSTITUTE(SUBSTITUTE(A1:D10,"L",""),"S",""))),2)
2=ROUND(AVERAGE(IF((LEFT(A1:D10)="L")*ISERROR(SEARCH("s",A1:D10)),--SUBSTITUTE(SUBSTITUTE(A1:D10,"L",""),"S",""))),2)
3若只有l、s、h这3个字母则=ROUND(AVERAGE(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1:D10,"L",""),"S",""),"H","")),2)否则若字母太多做不了
都数组公式，同时按ctrl+shift+回车三键结束
