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

[µo°Ý] ±Æ°£¦³µù°O¤§¤@¬q°Ï¶¡¥[Á`

[µo°Ý] ±Æ°£¦³µù°O¤§¤@¬q°Ï¶¡¥[Á`

¥ý¶i¡G
§Úªº°ÝÃD¬O¡A²Î­p«~¶µ¬Û¦P¡A¦ýµù°O¤¤¦³v»Pb­n±Æ°£¡A½Ð°Ý­n¦p¦ó°µ¡H

°ÝÃD31-¤@¬q°Ï¶¡ªº²Î­p.rar (6.62 KB)

§Æ±æ¤ä«ù!

¦^´_ 1# s7659109


    F3=SUMPRODUCT((A2:A26=E3)*(C2:C26=""),(B2:B26))    ©¹¤U©Ô

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD