[注意]函入4期第9讲作业上交贴（1，2，3组）

cool_bao921

游客，如果您要查看本帖隐藏内容请回复

[em06][em06][em01][em01][em01][em01][em01][em01][em01]

gt90

<p>补课</p>[em04]

EP江淮

第4题第2问再补一个简化的公式，忽然发现SUMIF的第二个参数还可以这样用

数组公式=MAX(SUMIF(A4:A30,A4:A30,C4:C30))

sxccb

一、1=SUM(LEN(A6:C10))
2=SUM(LENB(A6:C10)-LEN(A6:C10))
3=C14-C16
4=SUM(N(CODE(A6:C10)=65))
  =COUNT(0/(1=FIND("A",A6:C10)))
5=COUNTIF(A6:C10,"A*")
6=SUM(LENB(LEFT(A6:C10))-1)
7=SUM((LEN(A6:C10)-LEN(SUBSTITUTE(UPPER(A6:C10),"EXCEL","")))/LEN("EXCEL"))
二、=TRIM(LEFT(A3,FIND("-",A3)-1))
=TRIM(MID(A3,FIND("-",A3)+2,99))
=TEXT(MIN(LEN(B3),1+LENB(B3)-LEN(SUBSTITUTE(B3," ",))),"[>30][DBNum1]g/通用格式字歌;[DBNum1]d字歌")
三、=TRIM(RIGHT(SUBSTITUTE(A3,"\",REPT(" ",99)),99))

vbyou127

59552