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

[µo°Ý] ±ø¥ó¦¡Á`¥[

[µo°Ý] ±ø¥ó¦¡Á`¥[

test1e.rar (3.85 KB)
½Ð±Ð¤j¤j¡Aªþ¥ó¤¤ªºÁ`¥[°ÝÃD¡AVBA¦p¦ó¼g¤~¯à°µ¨ì¡AÁÂÁÂ!

test1e.rar (3.94 KB)
¦p¦h¤@­Ó±ø¥ó¡AÀ³¦p¦ó¼g¡A¦A¦¸ÁÂÁ¤j¤j!

TOP

­n¸ò¦U¤j¤j»¡¥y¹ï¤£°_¡A¤§«eªº¨Ò¤l¡A¦Û¤v¦bÅÞ¿è¤W¥X¤F°ÝÃD¡A¾ã²z«ä¸ô«á¡A¦A¤W¶Ç¥¿±`ªºªþ¥ó¡A·Ð½Ð¤j¤j¦AÀ°¦£¡AÁÂÁÂ!
test2e.rar (4.09 KB)

TOP

¦^´_ 3# donod
ÅÞ¿è¤W(+38) ³o¼Ë¤£¬O¼Æ¦rµLªk­pºâ
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ donod ©ó 2013-9-27 17:56 ½s¿è
¦^´_  donod
ÅÞ¿è¤W(+38) ³o¼Ë¤£¬O¼Æ¦rµLªk­pºâ
GBKEE µoªí©ó 2013-9-27 17:28

(38)¥i§_?
test2e.rar (4.09 KB)

test2e.rar (4.09 KB)

TOP

¥»©«³Ì«á¥Ñ donod ©ó 2013-9-27 18:05 ½s¿è
¦^´_  donod
ÅÞ¿è¤W(+38) ³o¼Ë¤£¬O¼Æ¦rµLªk­pºâ
GBKEE µoªí©ó 2013-9-27 17:28

§ï¥Î[38 ] ¥N´À(+38 )¥i§_?
test2e2.rar (4.08 KB)

test2e2.rar (4.08 KB)

TOP

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

°}¦C¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
ÁÂÁ¤j¤j¡AB10¤]¥i¥H¡C
B9={COUNT(IF(LEFT(B15:D20)="[",(--MID(B15:D20,2,LEN(B15:D20)-2)<=B4)*(C15:E20>=B2)))}
¥H¤W¦³¤°»ò¤£¥¿½T?
test2e3.rar (4.34 KB)

TOP

¦^´_ 8# donod


    B9 =SUMPRODUCT(IF(LEFT(B15:D20)="[",(--MID(B15:D20,2,LEN(B15:D20)-2)<=B4)*(C15:E20>=B2)))
°}¦C¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD