[µo°Ý] §ì¨ú¸ê®Æ

013160

¤U¸ü (9.2 KB)
­q³æ

2017-9-23 14:19

­q³æ¸¹½X¥u¦³¤@­Ó
«¬¸¹¦³¦h­Ó

¤U¸ü (12.99 KB)
»s¥O

2017-9-23 14:20

»s¥O³æ¸¹½X¥u¦³¤@­Ó
«¬¸¹¦³¥i¯à¬O¦h­Ó¤]¥i¯à¥u¦³¤@­Ó

¤U¸ü (10.92 KB)
µ²ªG

2017-9-23 14:20

·Q¦b"­q"¤u§@ªí¤¤¦h¤@­ÓÄæ¦ì©ñ»s¥O³æ¸¹½X
¤£ª¾¹DÀ³¸Ó­n¦p¦ó¼g¤J¤½¦¡©Îµ{¦¡
­q-»s.rar (10.27 KB)

¤U¸ü¦¸¼Æ: 9

2017-9-23 14:18

013160

¦^´_ 2# zheng211016

½Ð°Ý¦pªG³o¤½¦¡§Ú¬O¿ù¦b­þ
=SUMPRODUCT((»s!D:D=A3)*(»s!B:B=B3)*»s!A:A)

¤U¸ü (12.23 KB)

2017-9-23 23:50

013160

§A¸Õ¸Õ¬Ý¥i¤£¥i¥H
zheng211016 µoªí©ó 2017-9-23 22:32

¦ý¬O§_ªG"»s"¤u§@ªí¤¤¦³­«ÂЪº«¬¸¹¬O§_§ì¨ú´N·|¿ù»~
©Ò¥H·Q­n³]¨â­Ó±ø¥ó­q³æ¸¹½X¸ò«¬¸¹¥h§ì¨ú»s¥O³æ¸¹

013160

¦^´_ 5# hcm19522

«¬¸¹­«ÂÐ.rar (9.08 KB)

¤U¸ü¦¸¼Æ: 2

2017-9-24 12:07

¸Õ¹L¤F¡A¦ý¥X¤£¨ÓÁٽФj¤jÀ°¦£

¤§«e¦³¤H±Ð§Ú¥Î¤U­±ªº¤½¦¡¡A¦ý¤£ª¾¹D­þ¸Ì¦³°ÝÃD¤]¬O¥X¤£¨Ó¡A¤£ª¾¹D¤j¤j¬O§_ª¾¹D
=SUMPRODUCT((»s!D:D=A3)*(»s!B:B=B3)*»s!A:A)

013160

¦^´_ 7# zheng211016


    «¬¸¹­«ÂÐ1.rar (10.09 KB)

¤U¸ü¦¸¼Æ: 7

2017-9-24 23:20

¤£¦n·N«ä§Ú¸Õ¤F¡A¦ý«o¥X²{¬Û¦Pªº¸¹½X!?
¬O§_¥i¸ÑÄÀ¤@¤U§Ú¬O¨º­ÓÀôµ²¥X¿ù¤F

¤U¸ü (15.15 KB)

2017-9-24 23:21

·PÁ§A­ÌµL¨pªºµªÂÐ

013160

¦^´_ 9# zheng211016

¹ï§q¨Sª`·N¨ì
­è­n§ï«o¥X²{¥H¤U°T®§

¤U¸ü (8 KB)

2017-9-26 00:08

¤£¥i¥Hª½±µ§âA2 §ïA3 B2§ïB3!?
§Oªº¤½¦¡¥iª½±µ§ï¤@¨â­Ó«áÂI¨â¤U´N·|¦Û°ÊÅÜ¡A¬°¦ó³o¤£¥i¥H!?

SORRY¡A°ÝÃD¦³ÂI¦h

013160

¦^´_  013160

    =SUMPRODUCT((»s!D=A3)*(»s!B:B=B3)*»s!A:A)

ª½±µ»PAÄæ¬Û­¼·|¥X²{¿ù»~¡A¬O¦]¬°A ...
joblyc017 µoªí©ó 2017-9-30 12:02

­q³æ-­q³æ³æ¸¹-©ú²Óªí.rar (477.05 KB)

¤U¸ü¦¸¼Æ: 3

2017-10-21 18:09

¤U¸ü (42.41 KB)

2017-10-21 18:09

½Ð°Ý§Ú¤S­þ­ÓÀô¸`¥X¿ù¤F!?

013160

¦]¬°§A¥þ³¡³£§ìB2&C2 = =
zheng211016 µoªí©ó 2017-9-25 12:54

«¬¸¹­«ÂÐ.rar (445.35 KB)

¤U¸ü¦¸¼Æ: 3

2017-10-21 18:29

¤U¸ü (25.92 KB)

2017-10-21 18:30

³o¤S¬O«ç¤@¦^¨Æ!?
¦³ªº¦³¥X²{¦³ªº¨S¥X²{!?