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

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

¦^´_ 9# ML089


    ·PÁÂML089ª©¥D «ü¾É...
    µy·L­×§ï¤@¤U§Aªº¤½¦¡=SUM(COUNTIF(A:A,"*"&REPT("*A",ROW(A1)+{-1,0})&"*")*{1,-1})
    rept¤ºªºA Åܦ¨*A
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

°Ñ¦Ò¬Ý¬Ý¡G
¢Ñ¢°¡×¢¯
¢Ñ¢±¡×¢°
¢Ñ¢²¡×¢±
¢Ñ¢³¡×¢²
¤½¦¡¡G
=SUMPRODUCT(N(MMULT(LEN(SUBSTITUTE(A$1:A$60,"A",{1,11})),{-1;1})=C1))
¡@
ªþÀÉ¡G¤º¦³¥H¤W¼Ó¼h¦U¤½¦¡ªºÅçÃÒ¤ñ¸û
http://www.funp.net/182953

TOP

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

¦n¦¡¤l

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

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

­è¦n³£¥i¥H°Ñ¦Ò
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

¦^´_ 14# ML089


    ¤£¦n·N«ä¡A¥ý¤J¬°¥D¡A¨S¬Ý²M·¡¡C
    ÁÂÁª©¤jªº«ü¾É¡C
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

­ì¨Ó¤@­Ó¨ç¦¡¦³³o»ò¤jªº¾Ç°Ý
¨ü±Ð£{

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD