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

[µo°Ý] ¤½¦¡ $©T©w¼Æ¦r·|ÅÜ

[µo°Ý] ¤½¦¡ $©T©w¼Æ¦r·|ÅÜ

=VLOOKUP(A2,Data!$A$1:$L$5000,12,0)

­Y§Ú§R´î¼W¥[DATA¸Ìªº¦C¼Æ $«á­±ªº¼Æ¦r·|Åܦ¨5001©Î4998

½Ð°Ý¦³¤°»ò¤èªkÅý¥L©T©w¤£ÅÜ

VLOOKUP(A2,Data!$A:$L,12,)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    §Ú¤§«e¦³¼g¹L¡A¦ý³o¼Ë¸ê®Æ·|¶]«Ü¤[¡C¦p¤U³o­Ó¤½¦¡
    =SUMIFS(Data!$F$1:$F$6221,Data!$N$1:$N$6221,$C2,Data!$P$1:$P$6221,$E2)

TOP

¦^´_ 3# annie.l


¦³¨Ç¨ç¼Æ¥i¥H¥þÄæ¤Þ¥Î, ¦³¨Ç«h·|³y¦¨­pºâ½wºC, ¦p±ø¥ó«¬ªº­pºâ,
¨Ï¥Î»²§UÄæ¥i¯à¦n¤@ÂI

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD