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

LOOK UP

LOOK UP

Åv­«ªí¤ÎÁ`¶i«×ªí.rar (23.33 KB) ½Ð°Ý¦U¦ì¤j¤j­Ì¡G
¤p§Ì©óH6~H22¨ç¼ÆµLªk¥¿½T¦^¶Ç¥¿½T¼Æ¦r¡A¥i½Ð¤j¤j­ÌÀ°§Ú¸ÑÄÀ¤@¤U!
¸ê®Æ°Ï©óT4:AZ22

¦^´_ 1# tufe8887


    h6=IF($M$2="","",SUMPRODUCT(($V$4:$AZ$4=$M$2)*($U$5:$U$22=B6)*$V$5:$AZ$22))

    ¦V¤U½Æ»s§Y¥i

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD