excelʹÓú¯Êý¶ÔSheet2¹¤×÷±íÖеġ°½±½ð¡±ÁÐÌî³ä**

ʱ¼ä£º2014.01.26 ·¢²¼ÈË£º¶îÃû×ÖÊÇʲô

excelʹÓú¯Êý¶ÔSheet2¹¤×÷±íÖеġ°½±½ð¡±ÁÐÌî³ä**

Òѽâ¾öÎÊÌâ

¹È¸è¶îÃû×ÖÊÇʲôÓû§ÔÚ2014.01.26Ìá½»Á˹ØÓÚ¡°¶¼ÊÐDZÁúexcelʹÓú¯Êý¶ÔSheet2¹¤×÷±íÖеġ°½±½ð¡±ÁÐÌî³ä**¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ3¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-01-19T09:23:31¡£

£¨2£©½«Sheet1¹¤×÷±íÖеÄ**¿½±´µ½Sheet2¹¤×÷±íA1µ¥Ôª¸ñ¿ªÊ¼µÄÇøÓò¡£Ê¹Óú¯Êý¶ÔSheet2¹¤×÷±íÖеġ°½±½ð¡±ÁÐÌî³ä**£¨Ö°³ÆÎª¡°¸ß¼¶¹¤³Ìʦ¡±ºÍ¡°¹¤³Ìʦ¡±µÄÔ±¹¤½±½ðÊÇ1500£¬Ö°³ÆÎª¡°ÖúÀí¹¤³Ìʦ¡±µÄÔ±¹¤½±½ðÊÇ1000£©£»¼ÆËãSheet2¹¤×÷±íÖÐÿλԱ¹¤µÄ¡°¹¤×ʺϼơ±£¨¹¤×ʺϼÆ=»ù±¾¹¤×Ê+½±½ð)¡£

´óÉñÕâ¸öÎÒҲû»áŪ~~

Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£º

£¨2£©½«Sheet1¹¤×÷±íÖеÄ**¿½±´µ½Sheet2¹¤×÷±íA1µ¥Ôª¸ñ¿ªÊ¼µÄÇøÓò¡£Ê¹Óú¯Êý¶ÔSheet2¹¤×÷±íÖеġ°½±½ð¡±ÁÐÌî³ä**£¨Ö°³ÆÎª¡°¸ß¼¶¹¤³Ìʦ¡±ºÍ¡°¹¤³Ìʦ¡±µÄÔ±¹¤½±½ðÊÇ1500£¬Ö°³ÆÎª¡°ÖúÀí¹¤³Ìʦ¡±µÄÔ±¹¤½±½ðÊÇ1000£©£»¼ÆËãSheet2¹¤×÷±íÖÐÿλԱ¹¤µÄ¡°¹¤×ʺϼơ±£¨¹¤×ʺϼÆ=»ù±¾¹¤×Ê+½±½ð)¡£

´óÉñÕâ¸öÎÒҲû»áŪ~~

ÆÚ´ýÄúµÄ´ð°¸£¬Ð»Ð»Äã°ïÎÒ,×£Äã¿ìÀÖ,Ô¸ÄãÊÂÊÂÈçÒâ £¡
Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºÏ§Å¨Ò**´  

Õâ¸öÒâ˼¾ÍÊǸù¾Ý²»Í¬µÄÖ°³Æ£¬¼ÓÉϲ»Í¬µÄ±ÈÀýµÄ½±½ð£¬Ê¤³Ìʦ¸ß¼¶¹¤³ÌʦµÄ¼Ó1500£¬ÖúÀí¹¤³ÌʦµÄ¼Ó1000

µÚ2¸ö»Ø´ð

Óû§Ãû£ºËæmg·ç  

ÒªÓõ½IFº¯Êý¡£

µÚ3¸ö»Ø´ð

Óû§Ãû£ºjtt92  

¼Ó·¨Óú¯ÊýSUM»ò×Ô¼ºÊäÈ빫ʽ=»ù±¾¹¤×Ê+½±½ðÒ½ÌøÒýÂÔÊÒ̬Â裨ÓþßÌåµ¥Ôª¸ñ±íʾ£©