ML089

B8 =SUMPRODUCT(IF(LEFT(B15:D20)="(",(--MID(B15:D20,2,LEN(B15:D20)-2)>=B2)*(C15:E20<B2)*(C15:E20>B4),),C15:E20)

°}¦C¤½¦¡

ML089

¦^´_ 8# donod


    B9 =SUMPRODUCT(IF(LEFT(B15:D20)="[",(--MID(B15:D20,2,LEN(B15:D20)-2)<=B4)*(C15:E20>=B2)))
°}¦C¤½¦¡

ML089

¦^´_ 8# donod


    ¦pªG­n¥Î COUNT ¦p¤U
B9 =COUNT(1/(IF(LEFT(B15:D20)="[",(--MID(B15:D20,2,LEN(B15:D20)-2)<=B4)*(C15:E20>=B2))))
°}¦C¤½¦¡

ML089

¦^´_ 13# donod

¬°¦ó±Nºñ¦â®æ[-30]§ï¬°K-30´N¤À§O¤£¥X¡A©w­n¦bK-30¤§«á¥[¦h¤@­Ó¦ì©O?ÁÂÁÂ!

A1="[-30]" ­n¨ú¥X-30 ¥Î MID(A1,2,LEN(A1)-2)¡A ª`·N LEN(A1)-2 ¤¤ªº -2 ´N¬O¦©°£«e«á²Å¸¹ "["¡B"]"

A1="K-30" ­n¨ú¥X-30 ¥Î MID(A1,2,LEN(A1)-1)¡A ª`·N LEN(A1)-1 ¤¤ªº -1 ´N¬O¦©°£«e²Å¸¹ "K"
·íµM¤@¯ë§Þ¥©©Ê§@ªk¥i¥Î  MID(A1,2,99)