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

ML089

¦^´_ 8# p212
1¡B¹ï©óREPT("A",ROW(A1)+{-1,0})¡A¬°¦ó¤£ª½±µ¥ÎREPT("A",ROW(A1)-1)¡H
2¡B¤SCOUNTIFµ²ªG*{1,-1}¡A¨ä*{1,-1}¥Î·N¦ó¦b¡H¦b»s³y¤°»ò¼Ëªº°}¦Cµ²ªG¨ÑSUM¹Bºâ¡H

¦^ÂÐ1
REPT("A",ROW(A1)+{-1,0}) ==> ·íA1®É REPT("A", {0,1}) = {"", "A"} ¥i±o¨â­Ó°}¦C­È
REPT("A",ROW(A1)-1) ==> ·íA1®É REPT("A", {0}) = {""} ¥i±o¤@­Ó°}¦C­È

¦^ÂÐ2
=SUM(COUNTIF(A:A,"*"&REPT("A",ROW(A1)+{-1,0})&"*")*{1,-1})
=SUM(COUNTIF(A:A,{"**","*A*"})*{1,-1})
=SUM({64,37}*{1,-1})
=SUM({64,-37})
=27
   
COUNTIF(A:A,"**") ¥i±o¥þ³¡ªº¼Æ¶q
COUNTIF(A:A,"*A*") ¥i±o*A*ªº¼Æ¶q
¨âªÌ¬Û´î´N¬O¤£§tAªº¼Æ¶q

³Æµù
** ¥]§t ¥þ³¡
*A*  ¥]§t *A*¡B*AA*¡B*AAA*
*AA* ¥]§t *AA*¡B*AAA*

ML089

¦^´_ 12# ­ã´£³¡ªL

¦n¦¡¤l

¶Q¦¡(12¼Ó)¸Ñªº¬O¦³´X­ÓA

§Ú(7¼Ó)¸Ñªº¬O A¡BAA¡BAAA¦³´X­Ó

­è¦n³£¥i¥H°Ñ¦Ò

ML089

¦^´_ 11# softsadwind

>>   µy·L­×§ï¤@¤U§Aªº¤½¦¡=SUM(COUNTIF(A:A,"*"&REPT("*A",ROW(A1)+{-1,0})&"*")*{1,-1})
>>   rept¤ºªºA Åܦ¨*A

§A­×§ïªº¦¡¤l»P§Ú­ì¦¡­pºâªº·N¸q¤£¦P¡A»P12¼Ó¬Û¦P¡A½Ð¸Ô13¼Ó»¡©ú

­pºâ *A*A*A* «¬¤½¦¡¦p¤U(¥ô·N±Æ¦C3­ÓA)
=SUM(COUNTIF(A:A,"*"&REPT("A*",ROW(A1)+{-1,0}))*{1,-1})
   

­pºâ *AAA* «¬¤½¦¡¦p¤U(³sÄò±Æ¦C3­ÓA)
=SUM(COUNTIF(A:A,"*"&REPT("A",ROW(A1)+{-1,0})&"*")*{1,-1})