ML089

¦^´_ 1# sunnyso

³oºâ½ì¨ýÃD

=SUM(COUNTIF(A:A,"*"&REPT("A",ROW(A1)+{-1,0})&"*")*{1,-1})
¤U©Ô
¬°4­Ó¤½¦¡(¦p¤U)²Î­p­È
0A
1A
2A
3A

sunnyso

±j¤H👍......

softsadwind

¦^´_ 4# sunnyso


    µw¬O­n¥Îcountif

1­ÓA =COUNTIF(A$1:A$100,"*A*")-COUNTIF(A$1:A$100,"AA*")-COUNTIF(A$1:A$100,"A*A")-COUNTIF(A$1:A$100,"*AA")+2*COUNTIF(A$1:A$100,"AAA")
2­ÓA =COUNTIF(A$1:A$100,"AA*")+COUNTIF(A$1:A$100,"A*A")+COUNTIF(A$1:A$100,"*AA")-3*COUNTIF(A$1:A$100,"AAA")

¤T­ÓA=COUNTIF(A$1:A$100,"AAA")
¨S¦³A =COUNTA(A$1:A$100)-COUNTIF(A$1:A$100,"*A*")

sunnyso

·PÁÂ.......

softsadwind

¦^´_ 1# sunnyso


    ¤T­ÓA =SUMPRODUCT((LEN(SUBSTITUTE(A1:A64,"A",""))=0)*1)
    ¨â­ÓA=SUMPRODUCT((LEN(SUBSTITUTE(A1:A64,"A",""))=1)*1)
    ¤@­ÓA=SUMPRODUCT((LEN(SUBSTITUTE(A1:A64,"A",""))=2)*1)
    ¤£§tA=SUMPRODUCT((LEN(SUBSTITUTE(A1:A64,"A",""))=3)*1)

     ¦pªG­n¥Îcountif ´N¬O­n¦h¤@Ä滲§U¦C
     B1=LEN(A1)-LEN(SUBSTITUTE(A1,"A","")) ¤U©Ô¡A¥hºâ¦³´X­ÓA ¡A©ÎªÌ¥Î³Q¨ú¥N¼Æ¨Ó¤Ï±À´X­ÓA

renfu

¥Ø«e·Q¨ìªº¤èªk¬O¥ÎLike ¥h°µ§PÂ_¡A
§Ú¤]¬O·s¤â¡A§Æ±æ¦^µª¹ï§A·|¦³À°§U ^^