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

[¤À¨É] ¥[Á`°ÝÃD!!! ¨D±Ï~~~

[¤À¨É] ¥[Á`°ÝÃD!!! ¨D±Ï~~~

¦U¦ì¤j¤j¦­¦w  ¤p§Ì¤S¨Óµo°Ý°ÝÃD¤F!!!

°ÝÃD¤º®e¦pªþ¥ó  ·P¿E¤£ºÉ!!!

³Â·Ð¤£­n¥Îªþ¥ó¡A¤p§Ìµ¥¯ÅÁÙ¤£°÷¨Sªk¤U¸ü¡A·P®¦^^ ¬¡­¶Ã¯1.rar (6.87 KB)
Jason

¦^´_ 1# eg0802

E5=SUMPRODUCT(REPLACE(C6:C17,1,FIND("-",C6:C17),"")*1)
E21=SUMPRODUCT(IF(C22:C33="",0,REPLACE(C22:C33,1,FIND("-",C22:C33),"")*1))   °}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ eg0802 ©ó 2012-3-11 22:00 ½s¿è

¦^´_ 2# register313


    R¤j±z¦n¡A¤p§Ì¥Î±zªº¤èªk¤§«á  ½Æ»s¤½¦¡  ¨S¦³¿ìªk¦Û°Ê§PÂ_­n¥[Á`ªºªø«×   ¦³¿ìªkÅý¥L¦Û°Ê§PÂ_ ©¹"¤U¥[Á`¥B¹J¨ìªÅ®æ´N°±¤î"¶Ü??
¤£µM³o¼Ë§Ú·|¥[Á`¨ì¨ä¥Lªº¸ê®Æ¡A¦³¿ìªkÅý¥L¦Û¤v§PÂ_¥[Á`ªºªø«×¶Ü??
¦]¬°§Ú¬O«Üªøªº¸ê®Æ(³£¦b¦P¤@Äæ¦ì)  ¦ý¤¤¶¡³£·|¦³ªÅ®æ°Ï¹j ¡C  ¦A¦¸³Â·Ð¦U¦ì¤j¤j¤F!!! thx

ÁÙ¦³¤@­Ó°ÝÃD¬O §Ú¤£À´¬°¤°»ò­n¥ÎSUMPRODUCT³o­Ó¨ç¼Æ¡A§Ú°O±o³o­Ó¨ç¼Æ¤£¬O¥Î¦b¥[Á`­¼¿n¤W¶Ü??  ³o­Ó¤]¬O§Ú¦bª¾ÃÑ®a°Ý¨Óªº¡A¦ý¦]¬°µLªk¦Û°Ê§PÂ_­n¥[Á`ªºªø«×©Ò¥H¤~¤W¨Ó¨D±Ï¡C
Jason

TOP

¦^´_ 3# eg0802

E21=SUMPRODUCT(REPLACE(DR,1,FIND("-",DR),"")*1)
©w¸qDR=INDIRECT("C"&ROW()+1&":C"&CELL("row",OFFSET(¤u§@ªí1!C22,MATCH("###",¤u§@ªí1!C22:C30000,0)-1,0))-1)
¥Î###§@­pºâ¤§°Ï¹j
1.jpg
2012-3-12 01:34

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD