=COUNTIF(B:B,G5) =COUNTIFS(B:B,G14,E:E,">20")
=COUNTIF(条件区域,条件)
=COUNTIFS(条件区域1,条件1,条件区域2,条件2……)
=IF(COUNTIF(A4,"*耳钉*"),"首饰","其他") =IF(ISERROR(FIND("耳钉",A4)),"其他","首饰")
=IF(MOD(MID(A4,15,3),2),"男","女")
=IF(ISODD(MID(A2,15,3)),"男","女")
=--TEXT(MID(A4,7,8),"0-00-00")
=DATEDIF(D4,TODAY(),"y")
=A4&"-"&B4
=PHONETIC(A4:K4)
=VLOOKUP(G4,$A$3:$E$9,MATCH(H4,$A$3:$E$3,0),0) =SUMPRODUCT(($A$4:$A$9=G4)*($B$3:$E$3=H4)*$B$4:$E$9)
=SUMIFS(C:C,A:A,E4,B:B,F4)
=LEFT(A4,LENB(A4)-LEN(A4)) =RIGHT(A4,2*LEN(A4)-LENB(A4))
=--LEFT(A4,FIND(" ",A4)-1) =--RIGHT(A4,LEN(A4)-FIND(" ",A4))
=LEFT(A4,FIND(IF(ISNUMBER(FIND("区",A4)),"区","省"),A4)) =RIGHT(A4,LEN(A4)-LEN(B4))
本文地址：百科问答频道 https://www.neebe.cn/wenda/868366_2.html，易企推百科一个免费的知识分享平台，本站部分文章来网络分享，本着互联网分享的精神，如有涉及到您的权益，请联系我们删除，谢谢！
相关阅读
