yh818ÒøºÓ

ÈçºÎÖÆ×÷Èë¿âÍøÕ¾ÎªÁËÂú×ãÖ÷¹Ë¸÷·½ÃæµÄÐèÇó £¬ÊµÊ±ÁË½â²¢ÕÆÎÕÔõÑù×öÈë¿âµç×Ó±í¸ñ²úÆ·µÄÁ÷Ïò¡¢Êг¡ÊÊÓ¦ÐÔ¡¢²úÆ·¼Û¸ñ¶¨Î»ÒÔ¼°¿Í»§¶Ô²úÆ·µÄÂúÒâˮƽ £¬ÌØÖƶ¨ÈçºÎÖÆ×÷Èë¿âÍøÕ¾µÄ²úƷЧÀͼƻ®¡£

±¾ÎÄĿ¼һÀÀ£º

  • 1¡¢ÔõÑùÓÃexcel×ö»õÎï½ø³ö¿â±íÎÒÏëÒªÒ»¸öÓÃEXCELÖÆ×÷ºÃµÄ»õ²Ö½ø³ö»õµÄ±í¸ñ...
  • 2¡¢ËÄ¿âһƽ̨ÊÇÔõÑùÈë¿âµÄ?
  • 3¡¢Õã½­Ê¡¸ß¼¶¹¤³ÌʦÈçºÎÈëר¼Ò¿â
  • 4¡¢ÈçºÎ½øÈë¹ú¼ÒÈ˲ſâ
  • 5¡¢ÊÕÖ§¿â±êÇ©ÔõÃ´ÖÆ×÷

ÔõÑùÓÃexcel×ö»õÎï½ø³ö¿â±íÎÒÏëÒªÒ»¸öÓÃEXCELÖÆ×÷ºÃµÄ»õ²Ö½ø³ö»õµÄ±í¸ñ...

1¡¢ÔÚEXCELÖÐÖÎÀí»õ²ÖÎïÆ·½ø³ö £¬¿ÉÒÔ»®·ÖʹÓÃSHEETSHEET2ºÍSHEET3Èý¸öÊÂÇé±íÀ´¼Í¼½ø»õÊýÁ¿¡¢³ö»õÊýÁ¿ºÍ¿â´æ¡£SHEET1ÓÃÓڼͼÿÌìµÄ½ø»õÇé¿ö £¬SHEET2¼Í¼ÿÌìµÄ³ö»õÇé¿ö¡£SHEET3ÔòÊÇ¿â´æ±í £¬ÕâÀï¿ÉÒÔÉèÖÃÒ»¸ö¹«Ê½ £¬×Ô¶¯ÅÌËã¿â´æÊýÁ¿ £¬¹«Ê½Îª£ºSHEET1Öнø»õÊýÁ¿ºÏ¼Æ-SHEET2Öгö»õÊýÁ¿¡£ÕâÑù×öÄܹ»È·± £¿â´æÊý¾ÝµÄʵʱ¸üС£

2¡¢ £¬ÏÈÔÚͬһÊÂÇé²¾ÖÐ×÷£º ¿â´æ»ã×Ü¡¢Èë¿â¡¢³ö¿â Èý¸ö±í¸ñ¡£2 £¬ÔÚ¿â´æ»ã×ܱíÖÐÊäÈëÊý¾Ý £¬È»ºóÑ¡ÖÐÐͺÅÁÐ £¬½«ÐͺÅÁÐÉèÖÃΪÐͺÅÊäÈëΨһÐÔ£¨ÖÆÖ¹Öظ´Í³¼Æ£©£ºÊý¾ÝÓÐЧÐÔ¡ª¡ªÉèÖãº×Ô½ç˵¡ª¡ª¹«Ê½£º=COUNTIF(B£ºB £¬B1)=1¡£ÍÉ»¯¾¯¸æ¡ª¡ªÍ£Ö¹¡£

3¡¢µÚÒ»²½£ºÐ½¨Ò»¸öÊÂÇé±í £¬²¢ÔÚÆäÖÐÊäÈë¿â´æÕËÄ¿µÄÄÚÈÝ¡£µÚ¶þ²½£º½«¡°¿â´æ½ø³ö¿â±í¸ñ¡±µÄÌâÄ¿µ¥Î»¸ñºÏ²¢²¢¾ÓÖÐ £¬×ÖÌåÉèÖÃΪËÎÌå¡¢×ֺżӴÖ¡£µÚÈý²½£º½«¡°ÉÏÔÂ½á´æ¡±¡¢¡°±¾ÔÂÈë¿â¡±¡¢¡°±¾Ô³ö¿â¡±ËùÔÚµ¥Î»¸ñºÏ²¢²¢¾ÓÖС£µÚËIJ½£º½«ËùÓÐÎÄ×ÖÉèÖÃΪ¾ÓÖÐ¶ÔÆë¡£µÚÎå²½£ºÎªÕûÕűí¸ñÌí¼Ó»ÒÉ«±ß¿ò¡£

4¡¢µÚÊ®²½£ºµã»÷µÚÈýÐеÄÏòÉϼýÍ· £¬ÔÙµã»÷½ø»õ±í £¬Ò³Ãæ»áÌø×ªµ½½ø»õ±í £¬Ñ¡ÖÐÊýÁ¿ËùÔÚµÄÕûÁУ¨¼´CÁУ© £¬Ñ¡ºÃºó £¬µã»÷È·¶¨¡£µÚʮһ²½£ºÈ·¶¨ºó £¬Ò³Ãæ»áÌø×ª»Ø½á´æ±í £¬Ñ¡ÖÐB2µ¥Î»¸ñ £¬°ÑÊó±ê·ÅÔÚµ¥Î»¸ñµÄÓÒÏÂ½Ç £¬µ±µ¥Î»¸ñ·ºÆð¡°+¡±ºÅʱ £¬°´×¡Êó±êÍùÏÂÀ­ £¬´ËΪ½«µÚ¶þµ¥Î»¸ñµÄ¹«Ê½Ìî³äµ½BÁÐÆäËûµÄµ¥Î»¸ñ¡£

5¡¢ÊÖ¶¯ÖÆ×÷Excel±í Éè¼Æ±í¸ñ½á¹¹£ºÌâÄ¿ÐУº°üÀ¨¡°ÈÕÆÚ¡±¡¢¡°Èë¿â/³ö¿â¡±¡¢¡°ÎïÆ·Ãû³Æ¡±¡¢¡°ÊýÁ¿¡±¡¢¡°¿â´æÓà¶î¡±µÈÁС£Êý¾ÝÐУºÓÃÓڼͼÿһ´ÎµÄÈë¿â»ò³ö¿â²Ù×÷¡£ÉèÖù«Ê½£ºÔÚ¡°¿â´æÓà¶î¡±ÁÐÖÐ £¬Ê¹Óù«Ê½À´×Ô¶¯ÅÌËã¿â´æ¡£

ËÄ¿âһƽ̨ÊÇÔõÑùÈë¿âµÄ?

Èë¿âÁ÷³Ì£º×¢²á£ºÔÚËÄ¿âÒ»Æ½Ì¨ÍøÕ¾ÉÏ×¢²áÒ»¸öÕ˺Š£¬²¢ÌîдÏàÓ¦µÄÐÅÏ¢¡£ÈÏÖ¤£ºÌá½»Ïà¹ØÈÏÖ¤ÖÊÁÏ £¬ÈçÆóÒµÓªÒµÖ´ÕÕ¡¢×éÖ¯»ú¹¹´úÂëÖ¤¡¢Ë°Îñ¹ÒºÅÖ¤µÈ¡£±¨ËÍ£ºÆ¾¾Ýƽ̨ҪÇó £¬±¨ËÍÆóÒµµÄÏà¹ØÊý¾Ý £¬ÈçÆóÒµ»ù±¾ÐÅÏ¢¡¢´ÓÒµÈËÔ±ÐÅÏ¢¡¢ÏîÄ¿ÐÅÏ¢µÈ¡£ÉóºË£ºÆ½Ì¨¶ÔÆóÒµ±¨Ë͵ÄÊý¾Ý½øÐÐÉóºË £¬ÉóºËͨʺ󼴿ÉÍê³ÉÈë¿â¡£

ËÄ¿âһƽ̨ £¬Êǹú¼Ò½¨ÉèÖ÷¹Ü×î¸ß²¿·ÖµÄÒ»¸öÊý¾Ý¿â £¬Ö»ÒªÊǹú¼Ò»®¶¨µÄ×¢²áÖ´ÒµÈËÔ±¶¼ÓиöÈËÒµ¼¨¼Í¼ £¬Í¨³£ÓÉ×¢²áÖ´ÒµÈËÔ±µÄµ¥Î»ÏòÊ¡¼¶½¨ÉèÖ÷¹Ü²¿·ÖÉ걨 £¬È»ºóÊ¡¼¶½¨É貿·ÖÔÙÏò½¨ÉèÖ÷¹Ü×î¸ß²¿·ÖÉóºË¼Èë¡£

Ê×ÏÈÔÚËÄ¿âÒ»Æ½Ì¨ÍøÕ¾ÉÏ×¢²áÒ»¸öÕ˺Š£¬²¢ÌîдÏàÓ¦µÄÐÅÏ¢¡£È»ºóÌá½»Ïà¹ØÈÏÖ¤ÖÊÁÏ¡£Æä´Îƾ¾Ýƽ̨ҪÇó £¬±¨ËÍÆóÒµµÄÏà¹ØÊý¾Ý¡£×îºóÆÚ´ýƽ̨¶ÔÆóÒµ±¨Ë͵ÄÊý¾Ý½øÐÐÉóºË £¬ÉóºËͨʺ󼴿ÉÍê³ÉÈë¿â¡£

½¨É貿ËÄ¿âһƽ̨¹¤³ÌÏîĿҵ¼¨Â¼Èë £¬ÆóÒµÐèҪƾ¾ÝÒÔϰ취½øÐÐ £¬²¢×¼±¸ÏàÓ¦µÄ×ÊÁÏ£ºÂ¼Èë°ì·¨ È«ÃæÂ¼ÈëÒªº¦ÐÅÏ¢£º°üÀ¨Ê©¹¤Í¼Éó²é¡¢ÕÐͶ±ê¡¢ÌõÔ¼±¸°¸¡¢ÖÊÁ¿Äþ¾²¼à¶½¡¢Ê©¹¤Ðí¿ÉºÍ¿¢¹¤±¸°¸µÈ»·½ÚµÄÐÅÏ¢¡£

ËÄ¿âһƽ̨ҵ¼¨Ö÷ÒªÓɽ¨ÖþÒµÆóÒµÂôÁ¦Â¼Èë¡£ÒÔÏÂÊǶԴËÎÊÌâµÄÏêϸ½â¼ÈëÖ÷Ì壺½¨ÖþÒµÆóÒµ£º×÷ΪËÄ¿âһƽ̨ҵ¼¨µÄÖ÷Òª¼ÓÈëÕß £¬½¨ÖþÒµÆóÒµÐèÒª½«ÆäÍê³ÉµÄ¹¤³ÌÏîĿҵ¼¨Â¼Èëµ½ËÄ¿âһƽ̨ϵͳÖС£Õâ°üÀ¨ÏîÄ¿µÄ»ù±¾ÐÅÏ¢¡¢Ê©¹¤Çé¿ö¡¢ÖÊÁ¿ÑéÊÕµÈÄÚÈÝ¡£

Ê×ÏȵǼ¼àÀíËÄ¿âһƽ̨¡£Æä´Î½øÈëÓұߵĽ¨ÉèÊÖÐøÒ»Ïî £¬×ó²à½¨ÉèÊÖÐøÒ»À¸ £¬µÚ¶þÌõ²Î½¨ÏîĿһÏîÀïÃæÄܹ»¼ì²ìµ½Ä㵥λËù¼àÀíµÄËùÓÐÏîÄ¿£»¿ÉÊÇǰÌáÊǸÃÏîÄ¿½¨É赥λ±ØÐëÒѾ­½øÐÐÌõÔ¼±¸°¸¡£×îºó²¢µÇ°¶¹ýËÄ¿âһƽ̨¡£

Õã½­Ê¡¸ß¼¶¹¤³ÌʦÈçºÎÈëר¼Ò¿â

Õã½­Ê¡¸ß¼¶¹¤³ÌʦÉêÇë½øÈëר¼Ò¿âµÄÒ»°ãÁ÷³ÌÈçÏ£ºÈ·¶¨Ä¿±êר¼Ò¿â£ºÊ×ÏÈ £¬ÐèÒªÃ÷È·Ï£Íû½øÈëµÄ¾ßÌåר¼Ò¿â £¬Õâ¿ÉÄÜÊÇÓëËùÔÚÐÐÒµÏà¹ØµÄÐÐҵЭ»á¡¢Õþ¸®»ú¹¹»òרҵ×éÖ¯µÄר¼Ò¿â¡£Á˽âÈë¿âÒªÇ󣺻á¼ûÄ¿±êר¼Ò¿âµÄ¹Ù·½ÍøÕ¾»òÏà¹Ø»ú¹¹ £¬×ÐϸÔĶÁ²¢Á˽âÈë¿âµÄ¾ßÌåÒªÇóºÍ³ÌÐò¡£

È·¶¨Ä¿±êר¼Ò¿â£ºÊ×ÏÈ £¬ÐèҪȷ¶¨ÄãÏ£Íû½øÈëµÄ¾ßÌåר¼Ò¿â¡£Õâ¿ÉÄÜÊÇij¸öÐÐҵЭ»á¡¢Õþ¸®»ú¹¹»òרҵ×éÖ¯µÄר¼Ò¿â¡£Á˽âÈë¿âÒªÇ󣺻á¼ûÄ¿±êר¼Ò¿âµÄ¹Ù·½ÍøÕ¾»òÏà¹Ø»ú¹¹ £¬Á˽âÈë¿âµÄ¾ßÌåÒªÇóºÍ³ÌÐò¡£ÕâЩҪÇó¿ÉÄܰüÀ¨×¨ÒµÅä¾°¡¢ÊÂÇé¾­Ñé¡¢Ö°³Æ¡¢Ñ§Êõ½á¹ûµÈ·½ÃæµÄÌõ¼þ¡£

¸ß¼¶¹¤³Ìʦ½øÈëÈ˲ſâµÄÒªº¦°ì·¨Ö÷Òª°üÀ¨ÒÔϼ¸µã£º»ñµÃ¸ß¼¶Ö°³ÆÖ¤Ê飺ÕâÊǽøÈëÈ˲ſâµÄ»ù´¡Ìõ¼þ £¬¸ß¼¶Ö°³ÆÖ¤ÊéÄܹ»Ö¤Ã÷¹¤³ÌʦµÄרҵÄÜÁ¦ºÍ¼¼Êõˮƽ¡£Ñ¡ÔñÊʺϵÄר¼Ò¿â£ºÆÀÉóר¼Ò¿â£ºÖ÷ÒªÓÉÊ¡¼¶²ÆÎñÌüÂôÁ¦ÖÎÀí £¬Í¨³£ÒªÇó¾ß±¸Öм¶ÒÔÉÏÖ°³Æ¼´¿ÉÉêÇë £¬Ö¼ÔÚΪÕþ¸®²É¹ºÏîÄ¿Ìṩרҵ֧³Ö¡£

¸ß¼¶¹¤³ÌʦÈçºÎ½øÈëÈ˲ſâ £¿»ñµÃ¸ß¼¶Ö°³ÆÖ¤ÊéÊÇÒªº¦Ò»²½ £¬Õâ¿ÉÒÔÈÃËûÃǼÓÈëÍâµØµÄÆÀÉó»òÆÀ±êר¼Ò¿â¡£Ä¿Ç° £¬È«¹ú¹æÄ£ÄÚµÄר¼Ò¿âÖ÷Òª·ÖΪÆÀÉóר¼Ò¿âÓëÆÀ±êר¼Ò¿âÁ½Àà £¬ÕâЩ¿âµÄÖÎÀíÉæ¼°¶à¸öÁìÓò¡£ÆÀÉóר¼Ò¿âÖ÷ÒªÓÉÊ¡¼¶²ÆÎñÌüÂôÁ¦ÖÎÀí £¬ÆäÈ«³ÆÎªÕþ¸®²É¹ºÆÀÉóר¼Ò¿â¡£

½øÈëÆÀ±êר¼Ò¿âÐèÂú×ã»ù±¾Ìõ¼þ²¢Í¨¹ýÉ걨¿¼ºË £¬¾ßÌåÁ÷³ÌÈçÏ£ºÂú×ã»ù±¾Ìõ¼þרҵ×ÊÖÊÒªÇó ´ÓÊÂÏà¹Ø×¨ÒµÁìÓòÊÂÇéÂú8Äê £¬²¢¾ßÓи߼¶Ö°³Æ»òͬµÈרҵˮƽ£¨Èç¸ß¼¶¹¤³Ìʦ¡¢½ÌÊÚ¼¶¸ß¹¤µÈ£©¡£¾ß±¸½Ï¸ßµÄÒµÎñËØÖʺÍÁ¼ºÃµÄְҵƷµÂ £¬ÊìϤÕбêͶ±ê¡¢Õþ¸®²É¹ºµÈÖ´¹æÂÉÔò¼°Õþ²ß¡£

ר¼Ò¿âµÄÖÖÀàÐí¶à £¬²î±ðµÄר¼Ò¿âÓвî±ðµÄÒªÇó¡£Ò»°ãÀ´Ëµ £¬ÈËÉç¾Ö·¢µÄ¸ß¼¶¹¤³ÌʦÏòר¼Ò¿âÖÎÀíµ¥Î»ÉêÇë £¬Ö»ÒªÉóºËͨ¹ýÁË £¬¾ÍÄܽø×¨¼Ò¿â¡£Ã¿Äêÿ½ìר¼Ò¿âÔÚ²»¾ø¸üР£¬Ò»µ©Í¬ÀàÐÍר¼Ò¼ºÉêÇëÂúÔ±ÁË £¬×¨¼Ò¿â½«²»ÔÙÏòÉç»áÕÐÆ¸ £¬±ØÐëÓÐÈËÍ˳ö»ò»»½ì²ÅÓÐʱ»ú³ÉΪר¼Ò¿âµÄÒ»Ô±¡£

ÈçºÎ½øÈë¹ú¼ÒÈ˲ſâ

1¡¢Òª½øÈë¹ú¼ÒÈ˲ſâ £¬¿ÉÒÔͨ¹ýÒÔÏÂÁ½ÖÖ;¾¶£º Ö±½ÓÌá½»ÉêÇëÖÁÈ˲ſâ°ì¹«ÊÒ ÉêÇëÁ÷³Ì£ºÉêÇëÈËÐè×¼±¸Ïà¹ØÖÊÁÏ £¬Ö±½ÓÌá½»¸ø¹ú¼ÒÈ˲ſâ°ì¹«ÊÒ¡£ÉóºËÓ붨¼¶£ºÈ˲ſâ°ì¹«ÊÒ»á¶ÔÉêÇëÖÊÁϽøÐÐ×îÖÕÉóºË £¬²¢Æ¾¾ÝÉêÇëÈ˵Ä×ÊÖʺÍÄÜÁ¦½øÐж¨¼¶¡£

2¡¢Òª½øÈë¹ú¼ÒÈ˲ſâ £¬ÉêÇëÈË¿ÉÒÔͨ¹ýÁ½ÖÖ;¾¶ÊµÏÖ¡£Ê×ÏÈ £¬ÉêÇëÈËÐèÒªÌá½»ÉêÇë £¬¾­¹ýÈ˲ſâ°ì¹«ÊÒµÄ×îÖÕÉóºËºÍ¶¨¼¶ £¬¼°¸ñºó»áÐû²¼Ö¤Êé £¬²¢ÔÚ¹ú¼ÒÈ˲ſâ¹Ù·½ÍøÕ¾¡ª¡ªÖйú¹ú¼ÒÈ˲ÅÍøµÄרҵÈ˲ſâÖÐÊÕ¼¡£

3¡¢Ö´·¨ÆÊÎö£ºÈë¿âÁ÷³Ì£ºÒªÁìÒ»£ºÉêÇëÈËÌá³öÉêÇë £¬È˲ſâ°ì¹«ÊÒ×îÖÕÉóºË¡¢¶¨¼¶ £¬Ðû²¼Ö¤Êé £¬ÊÕ¼µ½Öйú¹ú¼ÒÈ˲ÅÍø×¨ÒµÈ˲ſâ¡£ÒªÁì¶þ£ºÉêÇëÈËÌá³öÉêÇë £¬ÐÅÏ¢ÊÕÂÞÊÂÇéÕ¾³õÉó £¬È˲ſâ°ì¹«ÊÒ×îÖÕÉóºË¡¢¶¨¼¶ £¬Ðû²¼Ö¤Êé £¬ÊÕ¼µ½Öйú¹ú¼ÒÈ˲ÅÍø×¨ÒµÈ˲ſâ¡£

4¡¢Èë¹ú¼ÒÈ˲ſâÊÇÖ¸¸ßУ½áÒµÉúÖб»ÌôѡΪÓÅÐãºó±¸È˲Š£¬²¢±»ÄÉÈë¹ú¼ÒϲãÉú³¤¼Æ»®µÄÈ˲ſâ¡£ÒÔÏÂÊǹØÓÚÈë¹ú¼ÒÈ˲ſâµÄÏêϸ½âÊÍ£ºÑ¡°Î»úÖÆ£ºÏ²ãºó±¸È˲ÅÑ¡°Î£ºÊÐÈËÁ¦Éç±£²¿·ÖºÍÏà¹Ø²¿·ÖÅɺϽ¨Á¢Ï²ãºó±¸È˲ÅÑ¡°Î»úÖÆ £¬Ã¿Äê´Ó¸ßУ½áÒµÉúÖÐÌôÑ¡³öÒ»Åú½Ü³öÕß¡£

5¡¢Ìá½»ÉêÇ룺¸öÈËͨ¹ýÍøÂç»òÆäËû;¾¶½øÈëÖйú¹ú¼ÒÈ˲ÅÍø £¬Ìá½»Èë¿âÉêÇë¼°Ïà¹ØÖ¤Ã÷ÖÊÁÏ¡£ ÉóºËÖÊÁÏ£º¹ú¼ÒÈ˲ÅÍø¶ÔÉêÇëÈËÌá½»µÄÖÊÁϽøÐÐÉóºË £¬ºËʵÐÅÏ¢µÄÕæÊµÐÔºÍÓÐЧÐÔ¡£ ×ÛºÏÆÀ¹À£º¶ÔÉêÇëÈ˵ĽÌÓýÅä¾°¡¢×¨Òµ¼¼Êõ¡¢ÊÂÇé¾­Ñé¡¢ÈÙÓþÖ¤ÊéµÈ½øÐÐ×ÛºÏÆÀ¹À¡£

ÊÕÖ§¿â±êÇ©ÔõÃ´ÖÆ×÷

ÖÆ×÷ÊÕÖ§¿â±êÇ©ÈçºÎÖÆ×÷Èë¿âÍøÕ¾µÄÒªÁìÊÇ£ºÏȽ¨Á¢Ò»¸ö´óÐÍÈçºÎÖÆ×÷Èë¿âÍøÕ¾µÄ±êÇ©(¼´ÈëÈëÒ³) £¬È»ºóµã»÷±ê×¢¹æÄ£°´Å¥¡£ÏȽ¨Á¢Ò»¸ö´óÐ͵ıêÇ©(¼´ÈëÈëÒ³) £¬È»ºóµã»÷±ê×¢¹æÄ£°´Å¥¡£ÈçÏÂͼËùʾ£ºÔÚÈëÈëÒ³ÀïÃæ £¬°´ctrl¼üµã»÷È·¶¨ £¬Äã¿ÉÒÔ¿´¼û±ê×¢ÌâÄ¿µÄÑùʽ £¬ÒÔ¼°ÕýÈ·ÉèÖà £¬ÈçÏÂͼËùʾ£ºÔÚÈëÈëÒ³ÀïÃæ £¬µã»÷·ÖÏí°´Å¥ £¬ÔÚ·ÖÏíÀïÃæ½«ÆäÌí¼Óµ½ÄãµÄÍøÕ¾µÄÍ·²¿ÇøÓò¡£

µÚÒ»²½£ºÏÈÖÆ×÷ÈýÕűí¸ñ£ºÒ»ÕŽø»õ±í¡¢Ò»ÕÅÏúÊÛ±í¡¢×îºóÒ»ÕÅ½á´æ±í¡£µÚ¶þ²½£ºÖÆ×÷½ø»õ±íµÄ±íÍ·¡£µÚÈý²½£ºÖÆ×÷Ïú»õ±íµÄ±íÍ·¡£µÚËIJ½£ºÖÆ×÷½á´æ±íµÄ±íÍ·¡£µÚÎå²½£º·­¿ª½á´æ±í £¬°ÑÊó±ê·ÅÔÚb2µ¥Î»¸ñ £¬Ö®ºóµã»÷¹«Ê¾À¸µÄfx¡£µÚÁù²½£ºµã»÷Ö®ºóÒ³Ãæ»áµ¯³ö¡°²åÈ뺯Êý¡± £¬Ñ¡Ôñ¡°SUMIF¡± £¬µã»÷È·¶¨¡£

½«¡°ÎïÆ·Ãû³Æ¡±·ÅÔÚÐбêÇ©¡£Æ¾¾ÝÄãÑ¡ÔñµÄÊÕÖ§¿â¼Í¼·½·¨ £¬½øÐÐÒÔÏÂÉèÖ㺷½·¨Ò»£ºÀàÐÍ-ÊýÁ¿Ê½ ½«¡°ÀàÐÍ¡±·ÅÔÚÁбêÇ©¡£½«¡°ÊýÁ¿¡±·ÅÔÚÖµÇøÓò £¬²¢ÉèÖÃÆäÅÌËã·½·¨ÎªÇóºÍ¡£½ûÓÃÐкÍÁеķÖ×鹦Ч¡£ÔÚÊý¾Ý͸ÊÓ±íÉÏ £¬ÓÒ¼üµã»÷¡°Èë¿â¡±»ò¡°³ö¿â¡±µÄÖµ £¬Ñ¡Ôñ¡°ÅÌËãÏ¡£ÊäÈëÃû³Æ¡°¿â´æ¡±¡£ÊäÈ빫ʽ£º=Èë¿â-³ö¿â¡£

ÈÕ³£Â¼ÈëÓëµ÷½â£ºÈÕ³£Â¼Èëʱ £¬¿ÉÒÔÆ¾¾ÝÐèÒªÔÚͬһÐмÈëÊÕÖ§¿âÊý¾Ý £¬Ò²¿ÉÒÔ»®·Ö¼Èë¡£Èç¹ûÐèҪǿµ÷ÈÕÆÚ £¬¿ÉÒÔ½«ÐòºÅÁиijÉÈÕÆÚÊäÈë»ò¼ÓÈëÒ»À¸ÈÕÆÚ¡£ÔÂĩͳ¼Æ£ºÑ¡ÖÐÊý¾ÝÇøÓò £¬²åÈëÊý¾Ý͸ÊÓ±í¡£½«¡¾ÊýÁ¿¡¿ºÍ¡¾½ð¶î¡¿Íϵ½¡¾ÊýÖµÇóºÍ¡¿¿òÄÚ £¬½«¡¾ÎïÁϱàºÅ¡¿ºÍ¡¾Ãû³Æ¡¿·ÅÈ롾ÐбêÇ©¡¿ÇøÓò¡£

ÈçºÎÖÆ×÷Èë¿âÍøÕ¾¸÷ÒµÎñÔ±±ØÐëÿÔÂÒ»´Î¶Ô¿Í»§½øÐÐ×ß·Ã £¬Á˽â²úÆ·ÐèÇóÐÅÏ¢¼°¿Í»§¶Ô²úÆ·µÄ·´Ó¦ £¬²¢½«Çé¿öʵʱ·´Ïì¸øÔõÑù×öÈë¿âµç×Ó±í¸ñ¡£×¨ÒµÏÖ´ú»¯×±ÐÞ½â¾ö¼Æ»®¡£ÎªÏû·ÑÕßÌṩ½ÏÓÅÖʵIJúÆ·¡¢½ÏÌùÇеÄЧÀÍ¡¢½Ï¾ß¾ºÕùÁ¦µÄÓªÏúģʽ¡£

°æÈ¨ËùÓУºÄþÏÄyh818ÒøºÓ»·± £¿Æ¼¼ÓÐÏÞ¹«Ë¾ ×ªÔØÇë×¢Ã÷À´ÓÉ
ÍøÕ¾µØÍ¼