¦U¦ìExcel°ª¤â¤j®a¦n
¤p§Ì²Ä¤@¦¸µo°Ý°ÝÃD
Y¦³¤£¨¬ªº¦a¤è
ÁٽЦh¦h«ü±Ð!!
°ÝÃD¦p¤U
¦b¯Ê®Æ©ú²Óªí¤À¶¤¤·Q¨D±o¹wp¶i³f®É¶¡ÂI
·|¨Ì®w¦s¹wpª¬ªpªí¤À¶¤¤ªº°Ñ¦Ò³æ¸¹¤Î§PÂ_®w¦s¼Æ
±a¦^¶i³f¤é´Á¨ì
¯Ê®Æ©ú²Óªí¤À¶¨D±oµª®×
§Ú¦b¯Ê®Æ©ú²Óªí¤À¶ªºLÄ榳·Qnªºµª®×
§Ú¥Î¤U¦C¤½¦¡±a¤£¥Xµª®×
{=INDEX(®w¦s¹wpª¬ªpªí!$C$2:$C$21,MATCH("¶i³f"&D2,®w¦s¹wpª¬ªpªí!$D$2:$D$21&®w¦s¹wpª¬ªpªí!$A$2:$A$21,1),1)}
¬G½Ð°Ý¦³¦ó¤½¦¡¥i°µ§PÂ_?
¸É¥R»¡©ú
±ø¥ó¤£¤@©wn·Ó¤p§Ì©Ò»¡ªº¥h¨D¸Ñ
¥un¯à¨D±oµª®×§Y¥i
¤p§Ìè¥ÎSUMPRODUCT¥h¨D§ì¤é´Á
·|«ÂÐ=.=||
ÁÂÁÂ!!
Book1.rar (16.94 KB)
|