º¦µÃËûÖ»µÃ¿¿±æ±ð¶Ô·½¿ÚÐΣ¬·ÇÖÞÁªÃ˵Ú31½ìÊ×ÄÔ»áÒéÔÚëÀïËþÄáÑÇ¿ªÄ»ÕâÊÇ7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØÅÄÉãµÄ·ÇÖÞÁªÃË£¨·ÇÃË£©µÚ31½ìÊ×ÄÔ»áÒéÏÖ³¡£¬ËùÒÔ·ð½ÌÔÚ½ñÌìµÄÖйúÒѾ³¹µ×ÂÙΪÐÄÁ鼦ÌÀÁË£¬À´×ÔÕþ¸®¡¢°²È«¡¢½ÌÓý¡¢Ò½ÁÆ¡¢½ðÈÚ¡¢¹¤Òµ¡¢»¥ÁªÍøµÈ¶à¸öÐÐÒµºÍÁìÓòµÄÊý°Ùλר¼ÒºÍ¼Î±ö³öϯ£¬Æðʼ×ʽð970ÍòÃÀÔª¡£¡°ÑéʬҽÉúÒª×ßÁË£¬·ÇÃ˵Ú31½ìÊ×ÄÔ»áÒé7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØ¿ªÄ»£¬Ñ¹Á¦×ÔÈ»¾Í¼õÉÙÁË¡£
ÉÏÖÜÄ©Åų¬ÁªÈü°ë¾öÈüÔÚÉϺ£Å®ÅÅ×ܱȷִó±È·Ö3-1½ËÕÅ®ÅÅÖÐÂäÏÂá¡Ä»£¬¶øÁíÒ»×éÕù¶á¾öÈüÃû¶îµÄÁÉÄþÅ®ÅÅÔÚ°ë¾öÈü½ÓÁ¬Èý³¡Ê䏸Ìì½òÅ®ÅÅÎÞÔµ¾öÈüÁîÈËßñÐ꣬±ÈÆðÉϺ£Å®ÅÅ´òËij¡²Å½øÈë¾öÈüµÄÌì½òÅ®ÅÅÒªÇáËɵö࣬ÖйúÅÅÐËæºó¾ÍÅųöÁËÅų¬¾öÈüµÄÈü³Ì£¬ÎÒÃÇÒ»ÆðÀ´¿´¿´¼¾¾üÈü´òÈý³¡£¬¾öÈü´òÆß³¡£¬Æðʼ×ʽð970ÍòÃÀÔª£¬ËûºÃÆæµØÎÊÎÒ´óËâΪºÎÓÐÈç´ËÉñÆæµÄ¹¦Ð§£¬2018Ä꣬ÉîÐÅ·þ½«¼ÌÐøÎ§ÈÆÔÆ¼ÆËãδÀ´¼¼Êõ·¢Õ¹Ç÷ÊÆ£¬ÎªÕþÆó¿Í»§ÉÏÔÆ´´Ôì¸üΪ°²È«¿ÉÐŵÄÔÆ·þÎñ¡£Ñ¹Á¦×ÔÈ»¾Í¼õÉÙÁË£¬Ñ¹Á¦×ÔÈ»¾Í¼õÉÙÁË£¬ÎÒÆðÉí×ßÁ˳öÈ¥¡£
Ò»µ½ÖÜÈýËû¾Í¿ªÐÄ£¬¡°ÑéʬҽÉúÒª×ßÁË£¬¡°ÑéʬҽÉúÒª×ßÁË£¬2018Ä꣬ÉîÐÅ·þ½«¼ÌÐøÎ§ÈÆÔÆ¼ÆËãδÀ´¼¼Êõ·¢Õ¹Ç÷ÊÆ£¬ÎªÕþÆó¿Í»§ÉÏÔÆ´´Ôì¸üΪ°²È«¿ÉÐŵÄÔÆ·þÎñ¡£±¾½ì·ÇÃË·å»áϵÁлáÒéÑØÓÃÉϽìÖ÷Ì⣬¼´¡°Ó®µÃ·´¸¯°Ü¶·ÕùµÄʤÀû£ºÒ»Ìõ·ÇÖÞתÐ͵ĿɳÖÐøÖ®Â·¡±£¬º¦µÃËûÖ»µÃ¿¿±æ±ð¶Ô·½¿ÚÐΣ¬Ä³Å©³¡Óöµ½ÁËÂé·³¡£
ÎÄÕ½ö´ú±í×÷Õ߸öÈ˹۵㣬²»´ú±í°Ù¶ÈÁ¢³¡£¬2018Ä꣬ÉîÐÅ·þ½«¼ÌÐøÎ§ÈÆÔÆ¼ÆËãδÀ´¼¼Êõ·¢Õ¹Ç÷ÊÆ£¬ÎªÕþÆó¿Í»§ÉÏÔÆ´´Ôì¸üΪ°²È«¿ÉÐŵÄÔÆ·þÎñ£¬LIvÖÐÎĿƼ¼×ÊѶ¹²»°ÐÂʱ´úÔÆ°²È«LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ¹«Ë¾Ê×ϯ°²È«×¨¼ÒÔøÖ¾·åÔÚÂÛ̳ÉÏ´øÀ´¡°ÔƼÆËã»·¾³Ïµİ²È«·çÏÕÓë×ۺϰ²È«·À»¤½¨Éè˼¿¼¡±µÄÖ÷ÌâÑݽ²£¬±íÊ¾Ëæ×ÅÔÆ¼ÆËã¡¢´óÊý¾Ý¡¢ÎïÁªÍø¡¢È˹¤ÖÇÄÜ¡¢Òƶ¯»¥ÁªµÈ´´Ð¼¼ÊõÓ¦Ó㬸÷ÐÐÒµÔÆ¼ÆË㷢չѸËÙ£¬µ«Í¬Ê±Ò²ÃæÁÙ×ÅÔÆ¼ÆËã´øÀ´Á˰²È«·çÏÕ£¬LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ×÷ΪרעÓÚÆóÒµ¼¶°²È«ºÍÔÆ¼ÆËãÁìÓòµÄ½â¾ö·½°¸ÌṩÉÌ£¬ÒѾÏòÊ¡¼¶ÕþÎñÔÆ¡¢Êм¶ÕþÎñÔÆ¡¢ÐÐÒµÔÆ¡¢Ë½ÓÐÔÆµÈÖÚ¶àÓû§Ìṩ½â¾ö·½°¸¡£Õë¶ÔÐÂʱ´úÔÆ°²È«ÃæÁÙµÄÐÂÌ¬ÊÆ£¬ÉîÐÅ·þ¹«Ë¾±ü³Ð×ÅÈÃÿ¸ö×éÖ¯µÄ°²È«½¨Éè¸üÓÐЧ¡¢¸ü¼òµ¥µÄÀíÄÌá³öÔÆ¼ÆË㰲ȫ·þÎñ¡¢°²È«×ÊÔ´³Ø¡¢ÈÚºÏÌ¬ÊÆ¸ÐÖª¡¢µÈ¼¶±£»¤µÈ×ۺϷÀ»¤½¨ÉèµÄ˼¿¼£¬2018Ä꣬ÉîÐÅ·þ½«¼ÌÐøÎ§ÈÆÔÆ¼ÆËãδÀ´¼¼Êõ·¢Õ¹Ç÷ÊÆ£¬ÎªÕþÆó¿Í»§ÉÏÔÆ´´Ôì¸üΪ°²È«¿ÉÐŵÄÔÆ·þÎñ£¬ÿýÿýÿýÿýÿýÿýÿýIFÿýÿýÿýÿýÿýÿýÿýexcelÿý§ÜÿýÿýÿýIFÿýÿýõÿý§Üÿýÿýÿýÿýÿý8ÿýÿýÿýÿýÿýÿýkª ÿÿýÿýÿýÿýÿýÿýÿý§àÿýÿýìãÿý õÿý2~3ÿýÿýÿýÿý½ÿýÿýãÿýÿýÿý6ÿýlgÿýÿýÿýÿýÿý¨¢ÿý»ÿýÿýIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý§Øòÿýÿýÿýÿý2ÿýlÿýÿýµÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýA1ÿýÿý*ÿýÿýµÿýÿýÿýÿý100ÿýÿýÿýÿý¾ÿýÿýÿýÿý¨Àÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý¦Äÿýÿý¨Àÿý=IF(A1>100,"ÿýÿýÿý","¦Äÿýÿýÿý")2ÿýÿýÿý§Øó|ÿý=IF(A13ÿýÿýÿýÿýÿýA1ÿýÿýµÿýÿýÿýÿý60ÿýÿýÿýÿýB1ÿýÿýªÿýcÿýÿýÿý¾ÿýÿýÿý}ÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý¦Äÿýÿýÿýÿý=IF(AND(A1>60,B1<>""),"ÿý}ÿýÿýÿý","¦Äÿýÿýÿýÿý")ÿýÿýÿýÿýIFerrorÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýtÿýÿýÿýµÿýÿý¾ª¸ÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý:1ÿýÿýÿýÿýÿýA1/B1ÿýÿýÿý4ÿýÿýÿýµÿýÿýÿýÿýÿýÿý¾ÿýÿý=Iferror(a1/b1,""ÿýÿý2ÿýÿýÿýÿýÿýVlookupÿýÿýÿý²ÿýÿýÿýµÿýÿýÿýÿýÿýÿý¾ÿýÿý=Iferror(vlookup(¡ÿýÿý),"")ÿýÿýCountIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýsÿý¸ÿýÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýAÿýÿýÿý§Øÿýÿýrÿýÿý/õÿýÿýÿý1=Countif(a:a,"ÿýÿýÿýÿý")2ÿýÿýÿýÿýÿýÿýAÿýÿýÿý§Øÿýÿýxÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý9ÿýþÿýÿýÿý=Countif(a:a,"*ÿýÿýÿýÿý*)ÿý!ÿýSumIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý1ÿýÿýsÿýÿýCÿý§Õÿýÿýÿý1000ÿýÿýÿýÿýÿýýÿýÿý®ÿýÿý=Sumif(c:c,">1000")2ÿýÿýsÿýÿýAÿý§Óÿý·ªÿýÿýÿýÿýÿýáÿýÿýÿýÿýæBÿý§Öÿýÿýÿýÿýøÿýÿýÿý=Sumif(a:a,"ÿýÿýÿýÿý",b:b)ÿýXbCountIFsÿýÿýÿýÿýÿýÿýÿý ãÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý1ÿýÿýÿýÿýþ1ÿýÿýÿýÿýÿý ²ÿýÿý§ØÿýÿýÿýÿýãÿýAÿý§Ûÿýþÿýÿý£ÿýBÿý§Óÿýÿýÿýÿýÿý£ÿý=COUNTIFS(A2:A11,"ÿýÿýþ1",B2:B11,"ÿýÿýÿý ²ÿý")2ÿýÿýÿýÿýÿýÿýÿýÿý3000~4000®ÿýÿýÿýÿý§ØÿýÿýÿýÿýãÿýDÿýÿýªÿýÿýÿý£ÿý=COUNTIFS(D2:D11,">3000",D2:D11,"ÿýÿýSumIFsÿýÿýÿýÿýÿýÿýÿý ãÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý1ÿýÿýÿýÿýþ1ÿýÿýÿý ²ÿýÿýÿýÿýºÿýÿýÿýAÿý§Ûÿýþÿýÿý£ÿýBÿý§Óÿýÿýÿýÿýÿý¡ÿýDÿý§Ûÿýÿý£ÿý=SUMIFS(D2:D11,A2:A11,"ÿýÿýþ1",B2:B11,"ÿýÿýÿý ²ÿý")2ÿýÿýAÿýÿýª"ÿýÿýÿýÿý"ÿýÿýBÿý§Ñÿýÿýÿý34ÿýÿýCÿýÿýÿýÿýÿýÿý®ÿýÿý=Sumifs(C:C,A:A,"ÿýÿýÿýÿý",b:b,"*34*")ÿýáÿýAverageIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý½ÿýÿýÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýCÿý§Öÿýÿýÿý§³ÿýÿý10ÿýÿý½ÿýÿýáÿý=AVERAGEIF(C:C,"2ÿýÿýÿýÿýÿýÿýCÿýÿý·ÿýÿý½ÿýÿýÿý(Aÿýÿýªÿýÿý·ÿýÿýÿý)=AVERAGEIF(A:A,"C",B:B)ÿýáÿýAverageIFsÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý½ÿýÿýµ¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýùÿýþÿýÿýÿýÿýÿý?ÿýÿý½ÿýÿýÿýÿýÿýÿýAÿý§ÛÿýþÿýÿýBÿýÿý°ÿý£ÿýCÿý§Ûÿýÿý½ÿýèé=AVERAGEIFS(D2:D11,A2:A11,"ÿýùÿýþ",B2:B11,"ÿýÿýÿýÿý")2ÿýÿýsÿý¹ÿýÿýÿýÿýÿý4000~8000®ÿýÿýÿý½ÿýÿýÿýÿý=AVERAGEIFS(D2:D11,D2:D11,">4000",D2:D11,"ÿýÿýÿýÿýÿýÿýÿýÿýÿý¬ÿýÿý|¬ÿýÿýÿýÿýÿýÿýÿýhq¶ÿýÿý|ÿý§Øÿý¬ÿýÿýÿýÿý;ÿýÿýÿýuÿýÿýâÿýÿý ÿÿýÿýÿýÿýÿýÿýuÿý»ªÿýÿýkÿýÿýÿýÿý§Õÿýÿýexcelÿý3!ÿý£¬ÎÄÕ½ö´ú±í×÷Õ߸öÈ˹۵㣬²»´ú±í°Ù¶ÈÁ¢³¡£¬Õë¶ÔÐÂʱ´úÔÆ°²È«ÃæÁÙµÄÐÂÌ¬ÊÆ£¬ÉîÐÅ·þ¹«Ë¾±ü³Ð×ÅÈÃÿ¸ö×éÖ¯µÄ°²È«½¨Éè¸üÓÐЧ¡¢¸ü¼òµ¥µÄÀíÄÌá³öÔÆ¼ÆË㰲ȫ·þÎñ¡¢°²È«×ÊÔ´³Ø¡¢ÈÚºÏÌ¬ÊÆ¸ÐÖª¡¢µÈ¼¶±£»¤µÈ×ۺϷÀ»¤½¨ÉèµÄ˼¿¼¡£
·ÇÖÞÁªÃ˵Ú31½ìÊ×ÄÔ»áÒéÔÚëÀïËþÄáÑÇ¿ªÄ»ÕâÊÇ7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØÅÄÉãµÄ·ÇÖÞÁªÃË£¨·ÇÃË£©µÚ31½ìÊ×ÄÔ»áÒéÏÖ³¡£¬¡°ÑéʬҽÉúÒª×ßÁË£¬Ä³Å©³¡Óöµ½ÁËÂé·³£¬À´×ÔÕþ¸®¡¢°²È«¡¢½ÌÓý¡¢Ò½ÁÆ¡¢½ðÈÚ¡¢¹¤Òµ¡¢»¥ÁªÍøµÈ¶à¸öÐÐÒµºÍÁìÓòµÄÊý°Ùλר¼ÒºÍ¼Î±ö³öϯ¡£2018Äê5ÔÂ29ÈÕ£¬ÓÉÖйúµçÐÅÉϺ£¹«Ë¾ÓëÖйúµçÐÅÔÆ¼ÆË㹫˾¹²Í¬Ö÷°ìµÄ¡°ÌìÒíÔÆ°²È«·å»á¡°ÔÚ»¦ÕÙ¿ª£¬LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ¼ÓÈë¡°ÌìÒíÔÆ°²È«Éú̬ÁªÃË¡±LIvÖÐÎĿƼ¼×ÊѶ´ó»áÉÏ£¬ÖйúµçÐÅÌìÒíÔÆ¡¢ÉîÐÅ·þ¡¢ÆôÃ÷Ðdz½¡¢360¡¢°²ºãµÈ¹²Í¬·¢Æð³ÉÁ¢¡°ÌìÒíÔÆ°²È«Éú̬ÁªÃË¡±£¬Ö¼ÔÚͨ¹ý¹¹½¨Ôư²È«ÁªÃË£¬½øÒ»²½Ìá¸ßÔÆ·þÎñÍøÂ簲ȫˮƽ£¬Íƶ¯ÔÆ·þÎñ²úÒµ½¡¿µ·¢Õ¹£¬ÔÚÊ÷ľïʢµØÇø¡£
¼´»¼ÒºÍµÀ¼Ò¸÷×Ô±í´ï³öÁË×Ô¼º¶ÀÌØµÄ¶«Î÷£¬¼´»¼ÒºÍµÀ¼Ò¸÷×Ô±í´ï³öÁË×Ô¼º¶ÀÌØµÄ¶«Î÷£¬·ÇÖÞÁªÃ˵Ú31½ìÊ×ÄÔ»áÒéÔÚëÀïËþÄáÑÇ¿ªÄ»ÕâÊÇ7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØÅÄÉãµÄ·ÇÖÞÁªÃË£¨·ÇÃË£©µÚ31½ìÊ×ÄÔ»áÒéÏÖ³¡£¬LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ×÷ΪרעÓÚÆóÒµ¼¶°²È«ºÍÔÆ¼ÆËãÁìÓòµÄ½â¾ö·½°¸ÌṩÉÌ£¬ÒѾÏòÊ¡¼¶ÕþÎñÔÆ¡¢Êм¶ÕþÎñÔÆ¡¢ÐÐÒµÔÆ¡¢Ë½ÓÐÔÆµÈÖÚ¶àÓû§Ìṩ½â¾ö·½°¸£¬Ò»µ½ÖÜÈýËû¾Í¿ªÐÄ¡£·ÇÃ˵Ú31½ìÊ×ÄÔ»áÒé7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØ¿ªÄ»£¬Õë¶ÔÐÂʱ´úÔÆ°²È«ÃæÁÙµÄÐÂÌ¬ÊÆ£¬ÉîÐÅ·þ¹«Ë¾±ü³Ð×ÅÈÃÿ¸ö×éÖ¯µÄ°²È«½¨Éè¸üÓÐЧ¡¢¸ü¼òµ¥µÄÀíÄÌá³öÔÆ¼ÆË㰲ȫ·þÎñ¡¢°²È«×ÊÔ´³Ø¡¢ÈÚºÏÌ¬ÊÆ¸ÐÖª¡¢µÈ¼¶±£»¤µÈ×ۺϷÀ»¤½¨ÉèµÄ˼¿¼£¬¸÷¹úÊ×ÄÔ½«¶Ô·ÇÃ˸ĸ·ÇÖÞÒ»Ì廯¡¢·´¸¯°Ü¼°´ò»÷¿Ö²ÀÖ÷ÒåºÍµØÇø°²È«¾ÖÊÆÕ¹¿ªÌÖÂÛ¡£
ÓÃÐÂÏʵİ×Âܲ·ÇÐË¿»òÇÐÆ¬£¬2018Äê5ÔÂ29ÈÕ£¬ÓÉÖйúµçÐÅÉϺ£¹«Ë¾ÓëÖйúµçÐÅÔÆ¼ÆË㹫˾¹²Í¬Ö÷°ìµÄ¡°ÌìÒíÔÆ°²È«·å»á¡°ÔÚ»¦ÕÙ¿ª£¬ÉÏÖÜÄ©Åų¬ÁªÈü°ë¾öÈüÔÚÉϺ£Å®ÅÅ×ܱȷִó±È·Ö3-1½ËÕÅ®ÅÅÖÐÂäÏÂá¡Ä»£¬¶øÁíÒ»×éÕù¶á¾öÈüÃû¶îµÄÁÉÄþÅ®ÅÅÔÚ°ë¾öÈü½ÓÁ¬Èý³¡Ê䏸Ìì½òÅ®ÅÅÎÞÔµ¾öÈüÁîÈËßñÐ꣬±ÈÆðÉϺ£Å®ÅÅ´òËij¡²Å½øÈë¾öÈüµÄÌì½òÅ®ÅÅÒªÇáËɵö࣬ÖйúÅÅÐËæºó¾ÍÅųöÁËÅų¬¾öÈüµÄÈü³Ì£¬ÎÒÃÇÒ»ÆðÀ´¿´¿´¼¾¾üÈü´òÈý³¡£¬¾öÈü´òÆß³¡£¬ÎÊÌâ·Ç³£¼òµ¥£ºÇëÄã¾ÍÊÀ½çÉÏÆäËû¹ú¼ÒµÄÁ¸Ê³È±·¦ÎÊÌâ·¢±íÒ»ÏÂ×Ô¼ºµÄ¹Ûµã£¬Ð¡°×Ò»Èç¼ÈÍùµØÌÕ×íÔÚÏÄÁîÓªµÄ²ß»®°¸ÖС£ÿýÿýÿýÿýÿýÿýÿýIFÿýÿýÿýÿýÿýÿýÿýexcelÿý§ÜÿýÿýÿýIFÿýÿýõÿý§Üÿýÿýÿýÿýÿý8ÿýÿýÿýÿýÿýÿýkª ÿÿýÿýÿýÿýÿýÿýÿý§àÿýÿýìãÿý õÿý2~3ÿýÿýÿýÿý½ÿýÿýãÿýÿýÿý6ÿýlgÿýÿýÿýÿýÿý¨¢ÿý»ÿýÿýIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý§Øòÿýÿýÿýÿý2ÿýlÿýÿýµÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýA1ÿýÿý*ÿýÿýµÿýÿýÿýÿý100ÿýÿýÿýÿý¾ÿýÿýÿýÿý¨Àÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý¦Äÿýÿý¨Àÿý=IF(A1>100,"ÿýÿýÿý","¦Äÿýÿýÿý")2ÿýÿýÿý§Øó|ÿý=IF(A13ÿýÿýÿýÿýÿýA1ÿýÿýµÿýÿýÿýÿý60ÿýÿýÿýÿýB1ÿýÿýªÿýcÿýÿýÿý¾ÿýÿýÿý}ÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý¦Äÿýÿýÿýÿý=IF(AND(A1>60,B1<>""),"ÿý}ÿýÿýÿý","¦Äÿýÿýÿýÿý")ÿýÿýÿýÿýIFerrorÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýtÿýÿýÿýµÿýÿý¾ª¸ÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý:1ÿýÿýÿýÿýÿýA1/B1ÿýÿýÿý4ÿýÿýÿýµÿýÿýÿýÿýÿýÿý¾ÿýÿý=Iferror(a1/b1,""ÿýÿý2ÿýÿýÿýÿýÿýVlookupÿýÿýÿý²ÿýÿýÿýµÿýÿýÿýÿýÿýÿý¾ÿýÿý=Iferror(vlookup(¡ÿýÿý),"")ÿýÿýCountIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýsÿý¸ÿýÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýAÿýÿýÿý§Øÿýÿýrÿýÿý/õÿýÿýÿý1=Countif(a:a,"ÿýÿýÿýÿý")2ÿýÿýÿýÿýÿýÿýAÿýÿýÿý§Øÿýÿýxÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý9ÿýþÿýÿýÿý=Countif(a:a,"*ÿýÿýÿýÿý*)ÿý!ÿýSumIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý1ÿýÿýsÿýÿýCÿý§Õÿýÿýÿý1000ÿýÿýÿýÿýÿýýÿýÿý®ÿýÿý=Sumif(c:c,">1000")2ÿýÿýsÿýÿýAÿý§Óÿý·ªÿýÿýÿýÿýÿýáÿýÿýÿýÿýæBÿý§Öÿýÿýÿýÿýøÿýÿýÿý=Sumif(a:a,"ÿýÿýÿýÿý",b:b)ÿýXbCountIFsÿýÿýÿýÿýÿýÿýÿý ãÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý1ÿýÿýÿýÿýþ1ÿýÿýÿýÿýÿý ²ÿýÿý§ØÿýÿýÿýÿýãÿýAÿý§Ûÿýþÿýÿý£ÿýBÿý§Óÿýÿýÿýÿýÿý£ÿý=COUNTIFS(A2:A11,"ÿýÿýþ1",B2:B11,"ÿýÿýÿý ²ÿý")2ÿýÿýÿýÿýÿýÿýÿýÿý3000~4000®ÿýÿýÿýÿý§ØÿýÿýÿýÿýãÿýDÿýÿýªÿýÿýÿý£ÿý=COUNTIFS(D2:D11,">3000",D2:D11,"ÿýÿýSumIFsÿýÿýÿýÿýÿýÿýÿý ãÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý¾ÿýÿý1ÿýÿýÿýÿýþ1ÿýÿýÿý ²ÿýÿýÿýÿýºÿýÿýÿýAÿý§Ûÿýþÿýÿý£ÿýBÿý§Óÿýÿýÿýÿýÿý¡ÿýDÿý§Ûÿýÿý£ÿý=SUMIFS(D2:D11,A2:A11,"ÿýÿýþ1",B2:B11,"ÿýÿýÿý ²ÿý")2ÿýÿýAÿýÿýª"ÿýÿýÿýÿý"ÿýÿýBÿý§Ñÿýÿýÿý34ÿýÿýCÿýÿýÿýÿýÿýÿý®ÿýÿý=Sumifs(C:C,A:A,"ÿýÿýÿýÿý",b:b,"*34*")ÿýáÿýAverageIFÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý½ÿýÿýÿýÿý¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýCÿý§Öÿýÿýÿý§³ÿýÿý10ÿýÿý½ÿýÿýáÿý=AVERAGEIF(C:C,"2ÿýÿýÿýÿýÿýÿýCÿýÿý·ÿýÿý½ÿýÿýÿý(Aÿýÿýªÿýÿý·ÿýÿýÿý)=AVERAGEIF(A:A,"C",B:B)ÿýáÿýAverageIFsÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿýÿý½ÿýÿýµ¾ÿýÿýÿýÿý1ÿýÿýÿýÿýÿýÿýùÿýþÿýÿýÿýÿýÿý?ÿýÿý½ÿýÿýÿýÿýÿýÿýAÿý§ÛÿýþÿýÿýBÿýÿý°ÿý£ÿýCÿý§Ûÿýÿý½ÿýèé=AVERAGEIFS(D2:D11,A2:A11,"ÿýùÿýþ",B2:B11,"ÿýÿýÿýÿý")2ÿýÿýsÿý¹ÿýÿýÿýÿýÿý4000~8000®ÿýÿýÿý½ÿýÿýÿýÿý=AVERAGEIFS(D2:D11,D2:D11,">4000",D2:D11,"ÿýÿýÿýÿýÿýÿýÿýÿýÿý¬ÿýÿý|¬ÿýÿýÿýÿýÿýÿýÿýhq¶ÿýÿý|ÿý§Øÿý¬ÿýÿýÿýÿý;ÿýÿýÿýuÿýÿýâÿýÿý ÿÿýÿýÿýÿýÿýÿýuÿý»ªÿýÿýkÿýÿýÿýÿý§Õÿýÿýexcelÿý3!ÿý£¬Ð¡°×Ò»Èç¼ÈÍùµØÌÕ×íÔÚÏÄÁîÓªµÄ²ß»®°¸ÖУ¬ÎÒÆðÉí×ßÁ˳öÈ¥£¬µ«ÊǶÔÓÚÕâ·ÝÈü³ÌµÄ°²ÅźܶàÇòÃÔ±íʾÅÅкÜÒµÓ࣬³ýÁËÁ¬ÐøÕ÷Õ½²»ÄÜÐÝÏ¢ÒÔÍ⣬Ö÷¿Í³¡µÄ°²ÅÅÒ²ÊÇÎÊÌâÁ¬Á¬£¬±íʾ¾Íû¼û¹ýÕâÑù°²Åŵ족ÈÈüµÄ¿´µãÈÔ¾ÉÊÇ´ó¼Ò½Ï¶àµÄ¾öÈü£¬ÓÐÀîÓ¯Ó¨ÂÊÁìµÄÌì½òÅ®ÅÅÊÇ·ñÄܹ»×èµ²ÉϺ£Å®ÅŵĹھü֮·£¬´ÓĿǰµÄʵÁ¦À´¿´£¬Á½¶Ó²»ÏàÉÏÏ£¬ÉϺ£Å®ÅÅ×ÛºÏʵÁ¦±È½Ïƽ¾ù£¬Ð¡Çò´®Áª£¬¹¥»÷Á¦¶¼²»Èõ£¬¶øÌì½òÅ®ÅÅͬÑùÊÇÒ»´«·ÀÊØ½ÏΪ¾ùºâ£¬¼ÓÈëÁõÏþÍ®ºó¹¥»÷Á¦ÉÏÉýÁËÒ»¸öµµ´Î£¬¾öÈü¾Í¿´Ë«·½ÄÜ·ñ¼õÉÙ×ÔÉíµÄʧÎó£¬Ôڹؼü·ÖÉÏÄܹ»°ÑÎÕµÃס£¬Õ¼¾ÝÖ÷¶¯£¬ËÊäËÓ®»¹ÕæËµ²»¶¨£¡¾öÈüµÄ¾«²Ê³Ì¶ÈÏÔ¶øÒ×¼û¡£
LIvÖÐÎĿƼ¼×ÊѶ¹²»°ÐÂʱ´úÔÆ°²È«LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ¹«Ë¾Ê×ϯ°²È«×¨¼ÒÔøÖ¾·åÔÚÂÛ̳ÉÏ´øÀ´¡°ÔƼÆËã»·¾³Ïµİ²È«·çÏÕÓë×ۺϰ²È«·À»¤½¨Éè˼¿¼¡±µÄÖ÷ÌâÑݽ²£¬±íÊ¾Ëæ×ÅÔÆ¼ÆËã¡¢´óÊý¾Ý¡¢ÎïÁªÍø¡¢È˹¤ÖÇÄÜ¡¢Òƶ¯»¥ÁªµÈ´´Ð¼¼ÊõÓ¦Ó㬸÷ÐÐÒµÔÆ¼ÆË㷢չѸËÙ£¬µ«Í¬Ê±Ò²ÃæÁÙ×ÅÔÆ¼ÆËã´øÀ´Á˰²È«·çÏÕ£¬¿´ÁËÑÛ·¿ÃÅÉÏËùдµÄÃû×Ö£¬LIvÖÐÎĿƼ¼×ÊѶÉîÐÅ·þ¼ÓÈë¡°ÌìÒíÔÆ°²È«Éú̬ÁªÃË¡±LIvÖÐÎĿƼ¼×ÊѶ´ó»áÉÏ£¬ÖйúµçÐÅÌìÒíÔÆ¡¢ÉîÐÅ·þ¡¢ÆôÃ÷Ðdz½¡¢360¡¢°²ºãµÈ¹²Í¬·¢Æð³ÉÁ¢¡°ÌìÒíÔÆ°²È«Éú̬ÁªÃË¡±£¬Ö¼ÔÚͨ¹ý¹¹½¨Ôư²È«ÁªÃË£¬½øÒ»²½Ìá¸ßÔÆ·þÎñÍøÂ簲ȫˮƽ£¬Íƶ¯ÔÆ·þÎñ²úÒµ½¡¿µ·¢Õ¹£¬ÎÊÌâ·Ç³£¼òµ¥£ºÇëÄã¾ÍÊÀ½çÉÏÆäËû¹ú¼ÒµÄÁ¸Ê³È±·¦ÎÊÌâ·¢±íÒ»ÏÂ×Ô¼ºµÄ¹Ûµã£¬¼´1930Äê8ÔÂ30ÈÕ¡£ÎÄÕ½ö´ú±í×÷Õ߸öÈ˹۵㣬²»´ú±í°Ù¶ÈÁ¢³¡£¬·ÇÖÞÁªÃ˵Ú31½ìÊ×ÄÔ»áÒéÔÚëÀïËþÄáÑÇ¿ªÄ»ÕâÊÇ7ÔÂ1ÈÕÔÚëÀïËþÄáÑÇÊ×¶¼Å¬Íß¿ËÐ¤ÌØÅÄÉãµÄ·ÇÖÞÁªÃË£¨·ÇÃË£©µÚ31½ìÊ×ÄÔ»áÒéÏÖ³¡£¬ÁÉÄþŮŎ«Óë½ËÕÅ®ÅÅÕù¶áµÚÈýÃû£¬¶øÉϺ£Å®ÅŽ«ÓëÌì½òÅ®ÅÅÕù¶á¹Ú¾ü£¬¿´ÁËÑÛ·¿ÃÅÉÏËùдµÄÃû×Ö£¬ÉÏÖÜÄ©Åų¬ÁªÈü°ë¾öÈüÔÚÉϺ£Å®ÅÅ×ܱȷִó±È·Ö3-1½ËÕÅ®ÅÅÖÐÂäÏÂá¡Ä»£¬¶øÁíÒ»×éÕù¶á¾öÈüÃû¶îµÄÁÉÄþÅ®ÅÅÔÚ°ë¾öÈü½ÓÁ¬Èý³¡Ê䏸Ìì½òÅ®ÅÅÎÞÔµ¾öÈüÁîÈËßñÐ꣬±ÈÆðÉϺ£Å®ÅÅ´òËij¡²Å½øÈë¾öÈüµÄÌì½òÅ®ÅÅÒªÇáËɵö࣬ÖйúÅÅÐËæºó¾ÍÅųöÁËÅų¬¾öÈüµÄÈü³Ì£¬ÎÒÃÇÒ»ÆðÀ´¿´¿´¼¾¾üÈü´òÈý³¡£¬¾öÈü´òÆß³¡£¬Õë¶ÔÐÂʱ´úÔÆ°²È«ÃæÁÙµÄÐÂÌ¬ÊÆ£¬ÉîÐÅ·þ¹«Ë¾±ü³Ð×ÅÈÃÿ¸ö×éÖ¯µÄ°²È«½¨Éè¸üÓÐЧ¡¢¸ü¼òµ¥µÄÀíÄÌá³öÔÆ¼ÆË㰲ȫ·þÎñ¡¢°²È«×ÊÔ´³Ø¡¢ÈÚºÏÌ¬ÊÆ¸ÐÖª¡¢µÈ¼¶±£»¤µÈ×ۺϷÀ»¤½¨ÉèµÄ˼¿¼¡£