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

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

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

­q³æ

1.PNG
2017-9-23 14:19

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

»s¥O

2.PNG
2017-9-23 14:20

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

µ²ªG

3.PNG
2017-9-23 14:20

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

§A¸Õ¸Õ¬Ý¥i¤£¥i¥H:D
2017-09-23_222855.png
2017-9-23 22:32

­q-»s.zip (71.5 KB)

TOP

¦^´_ 2# zheng211016

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

TOP

§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³æ¸¹

TOP

{=INDEX(»s!A$2:A$11,MATCH(A2&B2,»s!D$2:D$11&»s!B$2:B$11,))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ 013160 ©ó 2017-9-24 12:09 ½s¿è

¦^´_ 5# hcm19522

«¬¸¹­«ÂÐ.rar (9.08 KB)
¸Õ¹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)

TOP

hcm19522 ¤j¤j¬O¹ïªº­ò!!!
¥u¬O§A¤£ª¾¹D¥L¬O°}¦C¤½¦¡
«¬¸¹­«ÂÐnew.zip (11.69 KB)
2017-09-24_155657.png
2017-9-24 15:56

TOP

¦^´_ 7# zheng211016


    «¬¸¹­«ÂÐ1.rar (10.09 KB)
¤£¦n·N«ä§Ú¸Õ¤F¡A¦ý«o¥X²{¬Û¦Pªº¸¹½X!?
¬O§_¥i¸ÑÄÀ¤@¤U§Ú¬O¨º­ÓÀôµ²¥X¿ù¤F
2.PNG
2017-9-24 23:21


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

TOP

¥»©«³Ì«á¥Ñ zheng211016 ©ó 2017-9-25 12:57 ½s¿è

¦]¬°§A¥þ³¡³£§ìB2&C2 = =

TOP

¦^´_ 1# 013160

F2=IFERROR(LOOKUP(2,1/(»s!$D$1:$D$65536&»s!$B$1:$B$65536=­q!A2&­q!B2),»s!$A$1:$A$65536),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD