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

[µo°Ý] ³sÄò¥[Á`¹J0°±¤î¥[Á`°ÝÃD

[µo°Ý] ³sÄò¥[Á`¹J0°±¤î¥[Á`°ÝÃD

³sÄò¥[Á`¹J0°±¤î¥[Á`°ÝÃD
¥Ñ¥ª¦Ü¤S¦Û°Ê¥[Á`,¹J¨ì0°±¤î¥[Á`
¦pªþ©Ò¥Ü

³sÄò¥[Á`¹J0°±¤î¥[Á`°ÝÃD.rar (2.78 KB)

¥[Á`

b6=MATCH(0,D6:W6,0)-1
¤U©Ô¡I

TOP

¥»©«³Ì«á¥Ñ asimov ©ó 2010-8-15 22:52 ½s¿è

¦pªG¤º®e³£¬O 1 »P 0
B6=MATCH(0,D6:W6,0)-1
¦V¤U½Æ»s

¦pªG¤º®e³£¬O¨ä¥L¼Æ¦r»P 0
B6=SUM(OFFSET(D6,0,0,1,MATCH(0,D6:W6,0)))
¦V¤U½Æ»s
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

·PÁÂoobird ¤Îasimov ¾Çªø§iª¾
b6=MATCH(0,D6:W6,0)-1
¦pªG¤º®e³£¬O¨ä¥L¼Æ¦r»P 0
B6=SUM(OFFSET(D6,0,0,1,MATCH(0,D6:W6,0)))

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD