¾È³çÇϼ¼¿ä °í°´´Ô
ºñÁîÆû ¼½ÄÁö¿ø¼ºñ½º ´ã´çÀÚÀÔ´Ï´Ù.
¹®ÀÇÁֽŠ³»¿ë ¼öÁ¤Ã³¸® ÇÏ¿´½À´Ï´Ù.
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é [¼½ÄÁö¿ø¼ºñ½º]¸¦ ÅëÇØ
¹®ÀÇÇØ Áֽøé Á¤¼º²¯ ´äº¯ µå¸®°Ú½À´Ï´Ù.
¾È³çÇϼ¼¿ä °í°´´Ô
ºñÁîÆû ¼½ÄÁö¿ø¼ºñ½º ´ã´çÀÚÀÔ´Ï´Ù.
¼ö½ÄÀÔ·Â :
=IF(ISBLANK(C10),"",VLOOKUP($C$10,¸ÅÀÔ¸ÅÃâÀü³âÀÌ¿ù¾×!$C$10:$D$1048576,2,FALSE)+J10-K10+SUMIF($C$14:$C$1048576,$C$10,$J$14:$J$1048576)-SUMIF($C$14:$C$1048576,$C$10,$K$14:$K$1048576))
À§ÀÇ ¼ö½Ä ÀÔ·ÂÇØ ÁÖ½Ã¸é µË´Ï´Ù.
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é [¼½ÄÁö¿ø¼ºñ½º]¸¦ ÅëÇØ
¹®ÀÇÇØ Áֽøé Á¤¼º²¯ ´äº¯ µå¸®°Ú½À´Ï´Ù.
¸ñ·Ïº¸±â>
|