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

¸óÀɮצ³±ø¥ó¥[Áo

¸óÀɮצ³±ø¥ó¥[Áo

«e½ú­Ì, ¦n
¤@±ø¸óÀɮצ³±ø¥ó¥[Áo¨ç¼Æ, ¦p¦ó§â¸ê®Æ®w1¤Î¸ê®Æ®w2¤º¬Û¦P½s¸¹¥[ÁoÅã¥Ü©óÁ`­pªí¤W,
¥IÀÉ, Á`­pªí¤º¦³»¡©ú, ¥ý¦æÁÂÁ«e½ú­Ì¨ó§U,
qq.rar (22.76 KB)

F4 =SUM(SUMIF(INDIRECT("[¸ê®Æ®w"&{1,2}&".xlsx]¤u§@ªí1!$B:$B"),B4,INDIRECT("[¸ê®Æ®w"&{1,2}&".xlsx]¤u§@ªí1!$L:$L")))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
ÁÂÁÂ,
¯¬§Ö¼Ö..

TOP

¦^´_ 2# ML089
¬Ý¨ì¦¹¤å, §Ú¤]¦³¤@­Ó¸óÀɦ³±ø¥ó¥[Áoµo°Ý, ¤]«Ü§Æ±æª©¤j¦^À³,
­É¥Î¤@¼Ó¼Ó¥DÀÉ, µy§@­×§ï, °ÝÃD¼g©óÁ`­pªí¤¤,
·P®¦, ÁÂÁÂ!!
kk.rar (17.48 KB)
hong912

TOP

¦^´_ 4# hong912


   =SUM(SUMIF(INDIRECT("[¦U­Ü®w¦s.xlsx]"&{"­»´ä","¤EÀs"}&"!$B:$B"),B4,INDIRECT("[¦U­Ü®w¦s.xlsx]"&{"­»´ä","¤EÀs"}&"!$L:$L")))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
°J¤ßÁÂÁÂ, ·P®¦!!
hong912

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD