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

[µo°Ý] ½Ð°Ý¤@¤U¦³ÃöEXCEL¤ñ¹ïªí®æµM«á±N¼Æ­È¿é¥X

[µo°Ý] ½Ð°Ý¤@¤U¦³ÃöEXCEL¤ñ¹ïªí®æµM«á±N¼Æ­È¿é¥X

½Ð°Ý¤@¤U¦U¦ì«e½ú­Ì
°²¦p¦³¹³¤U­±¹Ï¤ù¤¤
·Q­n±N¤ñ¹ïA2:A11»PF15:O15
µM«á±NB2:B11ªº¼Æ­È¶ñ¤J¨ìF16:O16¤¤
¤£ª¾¹D¬O§_¦³¨ç¼Æ¥i¥H¨Ï¥Î©Î¬OVBA¥i¥H¨Ï¥Î
ÁÂÁ¤j®a

¦^´_ 1# coyote
½Ð©óF16Àx¦s®æ¿é¤J=VLOOKUP(F$15,$A:$B,2,0)¡A¦A¦V¥k½Æ»s¤½¦¡§Y¥i¡A½Ð°Ñ¦Ò¡C

TOP

¼Ó¤W¥¿¸Ñ;
¦p¤U¤]¦æ
©óF16Àx¦s®æ¿é¤J=SUMIF($A$2A$11,F$15,$B$2B$11), ¦A¦V¥k½Æ»s¤½¦¡.
¦n³B¬O·íAÄ榳­«½Æ©Î¯Ê¤ÖF15:O15©Ò¦C¤§¶µ¥Ø®É, ¥i§¹¾ã³Q­pºâ©ÎÁקK#N/Aªº¥X²{,
¦ý­YBÄ椣¬O¼Æ¦r®É«h¤£¾A¥Î.

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD