ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¥i§_¥Îcountif? ­Y¬O¦p¦ó?

¦^´_ 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
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

±j¤H👍......
ss

TOP

¦^´_ 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*")
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

·PÁÂ.......
ss

TOP

¦^´_ 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
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

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

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD