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

[µo°Ý] ¨D§U ... ²³æªº¥[Á`¤½¦¡

[µo°Ý] ¨D§U ... ²³æªº¥[Á`¤½¦¡

¦U¦ì¤j¤j¥i¥HÀ°À°§Ú¥Î ­Ó²³æ¥[Á`ªº¤½¦¡¶Ü .... test.rar (10.67 KB)


¤W¯Z±Ú¨S®É¶¡¬Ý®Ñ...¦Ñª©­n¨D¥u¦n¨Ó¨D§U¦U¦ì¤j¤j
jacky

B1=COUNTIF(¤u§@ªí4!$A$2 :$A$1087,¤u§@ªí1!A2)
¦A¦V¤U½Æ»s

TOP

¦^´_ 2# aer

¥[Á`¦Ó«D­p¼Æ
B2=SUMIF(¤u§@ªí1!A:B,¤u§@ªí4!A2,¤u§@ªí1!B:B)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥H¸Ñ¨M·PÁ¤j¤j«ü¾É
jacky

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD