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

[µo°Ý] ½Ð°Ý¯à¦A²¤Æ¤½¦¡¶Ü(´M§ä¬Û¹ïÀ³ªº­È)

[µo°Ý] ½Ð°Ý¯à¦A²¤Æ¤½¦¡¶Ü(´M§ä¬Û¹ïÀ³ªº­È)

½Ð°Ý´M§ä¬Û¹ïÀ³ªº­È.,¬O§_¦³§ó²¤Æªº¤è¦¡

¦]¬°¤½¥q¬°Âª©ªºEXCEL¨S¦³IFERRORªº¥\¯à¨ç¼Æ
¦pªG¤S¥ÎISNA¤½¦¡¤S«Üªø
¸ê®Æªí¥i¯à¤§«á¤S·|«Ø¥ß¦b¥t¤@­Ó¤u§@ªí
©Ò¥H¤½¦¡ªºªø«×.¦³ÂIÅå¤H
½Ð°Ý¬O§_¯à¦A²¤Æ¤½¦¡
ÁÂÁÂ

½Ð¸ÔÀÉ,·PÁÂ

½Ð°Ý¯à§ó²¤Æ¤½¦¡ªº¤èªk(´M§ä¬Û¹ïÀ³ªº­È).rar (9.55 KB)

¨D²¤Æ¤½¦¡

h5=IF(COUNTIF($A$4:$D$4,H$4)*COUNTIF($A$5:$A$7,$G5),(VLOOKUP($G5,$A$4:$D$7,MATCH(H$4,$A$4:$D$4,),)),0)¬Ù¤£¤F¦h¤Ö

TOP

H5=LOOKUP(9^9,IF({1,0},0,VLOOKUP($G5,$A$4:$D$7,MATCH(TEXT(H$4,0),$B$4:$D$4,0)+1,0)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

H5=SUMPRODUCT((H$4=$B$4:$D$4)*($G5=$A$5:$A$7)*$B$5:$D$7)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ¦U¦ìªº¦^ÂÐ....
­ì¨ÓÁÙ¦³³o¨Ç¤½¦¡¥i¥H¨Ï¥Î...
Åý§Ú¾Ç¨ì¤F¤£¤Ö..
ÁÂÁÂ~

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD