­«¥Í©x�õ¬x_§½ªï°ù°Æ¬Ù¤dª÷

²Ä34³¹ µ}¯Ê¤H¤~¡I

Ãþ§O¡J¥È¤ÛÅ]ªk §@ªÌ¡J�[ªe ¥»³¹¡J²Ä34³¹ µ}¯Ê¤H¤~¡I

    ·¡©¶³Q±a¨ì¤Fºî¦X¤@³Bªº¤@¶¡¤p¿ì¤½«Ç¡C

    ¿ì¤½ÆU¨½¦³¤@¥x¹q¸£¡A¬O¨ººØ²Â­«ªº¤j§¾ªÑ¹q¸£¡A«Ì¹õ¤]¬O¨ººØ¤À¿ë²v«Ü®tªº«Ì¹õ¡A¤@°{¤@°{ªº¡A¬Ý¤[¤FÅý¤H²´´Ø¯k¡C

    ·¡©¶¦b¹q¸£«e§¤¤U¡A¥´¶}ecel³n¥ó¬Ý¤F¤@¤U¡Aµo²{¹q¸£¦w¸Ëªº¬O¡A·L³n¦b1999¦~1¤ë¤W½uªºoffice 2000¡C

    ·í¤UªQ¤F¤@¤f®ð¡A³o´Ú³n¥óÁö»¡¤£°÷´¼¯à¡A¦ý¨D©MªºSUm¨ç¼Æ¡A©M¨D¥­§¡­ÈªºAVERAGE¨ç¼Æ¤½¦¡µ¥³£¦³¡A¤]ºâ«j±j°÷¥Î¤F¡C

    §d¤j´¼©Û©I¨ä¥L¤H§â»Ý­n³B²zªº°]°È¼Æ¾Ú·h¨ì¤F¹q¸£®ÇÃä¡C

    ·¡©¶®³°_³Ì¤W­±ªº¤@­¶¬Ý¤F¤@¤U¡Aµo²{ºî¦X¤@³B¤À°t¨ìªº¼Æ¾Ú¡A¬Oº~ªF¿ûÅKµ¥°ê¥ø­û¤uªº¤u¸ê¡B¼úª÷¼Æ¾Ú¡C

    ¡§·¡©¶¡A³o»ò¦h­û¤uªº¤u¸ê¼úª÷¡A§A¤@­Ó¤H¿é¤J¹q¸£±o¯Ó¨ì¤°»ò®É­Ô¡H¡¨

    §d¤j§Ó¦³¨Ç¬°Ãø¦a¹D¡A¡§¥»¨Ó§Ú­Ì¤T­ÓÀ°§A¤@°_¿é¤J§ó§Ö¡A¦ý¬O§Ú­Ì³¡ªù´N³o¤@¥x¹q¸£¡A¥i«ç»ò¿ì¡H¡¨

    ·¡©¶¦¹¨è¤]·Pı¡A±N¼Æ¾Ú¿é¤J¹q¸£ªº¹Lµ{¬O­Ó·¥¤jªº¤u§@¶q¡I

    «á¥@¦³¤@´Ú³n¥ó¡Aª½±µ¹ïµÛ¯È½è¤åÀÉ©ç·Ó¡A§Î¦¨pF¡AµM«á´N¥i¥H¹ê²{¥ÑpF¨ìor¡Becel¡BpptªºÂà¤Æ¡A¤Q¤À«K±¶¡C

    ¦ý²´«e©úÅã¨S¦³¨º´Ú³n¥ó¡C

    §O»¡³n¥ó¤F¡A²{¦bªº¤â¾÷³s©ç·Ó¥\¯à³£¨S¦³¡A°ò¥»´N¥u¯à¥´¹q¸Ü©Mµo«H®§¡C

    ¡§³Bªø¡A³o¼Ë§a¡A¦w±Æ¤@­Ó¤H±N¸ê®Æ¤Wªº«H®§³øµ¹§Ú¡A§Ú¨Ó¿é¤J¹q¸£¡A©¯¦n§Ú¥´¦r³t«×¨¬°÷§Ö¡K¡K¡¨

    ·¡©¶¤]¦³¨ÇµL©`¡C

    ³o¬O®É¥Nªº§½­­©Ê¡A®Ä²v¤£°÷¡A®É¶¡¨Ó´ê¡I

    §d¤j§Ó·Q¤F·Q«á¹D¡A¡§¥Ø«e¤]¥u¯à³o¼Ë¤F¡A«B¸Ö¡A§A¨Óµ¹·¡©¶³ø¸ê®Æ¤Wªº«H®§¡A¤k«Ä¤l²Ó¤ß¤@ÂI¡A­n¬Ý¥J²Ó¡A¥i¤d¸U§O·d¿ù¤F¡I¡¨

    ¡§¦nªº¡A³Bªø¡I¡¨

    ±µ¤U¨Ó¡AªL«B¸Ö§¤¦b·¡©¶®ÇÃä³ø¸ê®Æ«H®§¡A·¡©¶¥´¶}ecel¡A±N¤W­±ªº©m¦W¡B³¡ªù¡B¤uÄÖ¡B¤u¸ê¡B¼úª÷µ¥«H®§¤À§O¿ý¤Jecelªí®æ¤¤¡C

    ¨ººØ·¥­Pªº¥´¦r³t«×©M¦æ¶³¬y¤ô¯ëªº¼ô½m¡AÅý¦b³õªº©Ò¦³¤H­Ë§l¤@¤f²D®ð¡C

    ´N³s­è­è¥X¨¥¼J¿Ø·¡©¶ªº§º¤¯§ë¡A¤]Åå³Y¦a±i¤j¤F¼L¤Ú¡C

    ¡§¥L¥´¦r¦n¹³¤£¥Î¬ÝÁä½L¡I¡¨

    Æ[¹î²Ó­Pªº§d¤j§Ó«Ü§Ö´Nµo²{¤F·¡©¶¥´¦r³t«×¶W§ÖªºÃöÁä¡C

    ¦b³õªº¤H³£±µÄ²¹L¹q¸£¡A¤]¹Á¸ÕµÛ¥´¹L¦r¡C

    ¦ý¤@Ãä¬Ý½Z¤l¡A¤@Ãä¬Ý«Ì¹õ¡AÁÙ­n¬d§äÁä½Lªº°Ê§@¤Óµh­W¤F¡I

    ¨S·Q¨ì·¡©¶®Ú¥»¤£¬ÝÁä½L¡A²´´Ø¤@ª½¥H¥­µøªº¨¤«×¨nµÛ«Ì¹õ¡C

    §º¤¯§ë¤]Åå³Y¦aÀü¤j¤F²´´Ø¡C

    ¤§«e·¡©¶¦b¥L²´¨½¡A´N¬O¤@­Ó¤£¤Á¹ê»Ú¡B¼M²³¨úÃdªº¤p¤¡¡I

    ¥B¤£»¡º~ªF¤j¾Çªº±Ð¾Ç³]¬I»·»·¤£¦pª÷³®¤j¾Ç¡A¦b³o­Ó¦~¥N¡A°£¤F»P­pºâ¾÷¬ÛÃöªº±M·~¡A¨ä¥L±M·~ªº²¦·~¥Í«Ü¤Ö¦³±µÄ²¨ì­pºâ¾÷ªº¾÷·|¡I

    ¥L¤]¬O¦bª÷³®¤j¾Ç¾Ç·|¤F¥´¦r¡A¦ý¥\¤OÁÙ³B¤_¡¥¤G«üÁI¡¦ªºªì¯Å¶¥¬q¡I

    ³o­Ó·¡©¶¤S¤£¬O­pºâ¾÷±M·~ªº²¦·~¥Í¡A«ç»ò·|¥´¦r³o»ò§Ö¡H

    ¡§·¡©¶¡A§A¬O«ç»ò°µ¨ì¥´¦r¤£¬ÝÁä½Lªº¡H¡¨

    ¯¸¦b¤@®Çªº¥Õ¤å°a¤]§Ô¤£¦í°l°Ý¡C

    ¡§³o­Ó²³æ¡A±NÁä½L¤Wªº¨C­ÓÁ䪺¨ãÅé¦ì¸m©M¥Î³~¥þ³¡°O¤U¨Ó¡A¥´¦rªº®É­Ô´N¬Ù¤F§CÀY¬d¬ÝÁä½Lªº®É¶¡¡A´N¯à³Ì¤jµ{«×¤W´£¤É®Ä²v¡I¡¨

    ·¡©¶»¡±o«Ü»´´y²H¼g¡A¨ä¥L¤H«o³£­±ÅSÃø¦â¡I

    ­n·Q¹F¨ì¨ººØµ{«×½Í¦ó®e©ö¡I

    ¡§¤å°a¡A¥ý¤£­n¥´ÂZ¥L­Ì¡I¡¨

    §d¤j§Ó½K¤F½K¬Ü¡C

    ¡§¦nªº¡A³Bªø¡I¡¨

    ¡K¡K¡K

    §Y«K¬O·¡©¶ªº¥´¦r³t«×§Ö¨ì­¸°_¡A¤]¨¬¨¬ªá¤F¤T­Ó¤p®É¤~±N³o§å¼Æ¾Ú¡A¦¨¥\¿ý¤J¹q¸£¡C

    ·¡©¶·Pı¦Û¤vªº¤â³£»Ä¤F¡I

    ¦ý³o®£©Æ³t«×¨Ì±N§d¤j§Óµ¥¤H¤j¬°¦YÅå¡C

    ­ì¥»¥L­Ì¥H¬°¿ý¤J³o¨Ç¼Æ¾Ú­n¤@­Ó¬P´Á¡A¨S·Q¨ì·¡©¶µuµu¤T­Ó¤p®É´N¸Ñ¨M¤F¡C

    ¡§·¡©¶¡A¤zªº¤£¿ù¡I²{¦b¨ì¶ºÂI¤F¡A§Ú­Ì¥ý¥h¦Y¶º¡A¦^¨Ó±µµÛ§Ë¡I²¦³º®Öºâ¼Æ¾Úªá¶Oªº®É¶¡§óªø¡I¡¨

    ¡§¤£¥Î¤F¡A³Bªø¡I¡¨

    ·¡©¶¯º¹D¡A¡§¨ä¹ê³Ì¯Ó¶O®É¶¡ªº¡A´N¬O±N«H®§¿ý¤J¹q¸£³o¤@¨B¡I«H®§¿ý¤J§¹¦¨¤§«á´N²³æ°Õ¡I¡¨

    »¡µÛ¡A¥L²¾°Ê¹«¼ÐÂIÀ»SUmIFS¨ç¼Æ¡A³o­Ó¤½¦¡¥i¥H¹ê²{§Ö³t¹ï¦h±ø¥ó³æ¦ì®æ¨D©M¡C

    um_range ¬O»Ý­n¨D©Mªº¹ê»Ú³æ¤¸®æ¡A¤]¬O¨Ï¥Î¤½¦¡ªº²Ä¤@­Ó°Ñ¼Æ¡C

    criteria_range1¬°­pºâÃöÁp±ø¥óªº²Ä¤@­Ó°Ï°ì¡A¤]¬O²Ä¤G­Ó°Ñ¼Æ¡C

    criteria1¬°±ø¥ó1¡A¬°°Ñ¼Æ¤T¡C

    criteria_range2¬°ÃöÁp±ø¥óªº²Ä¤G°Ï°ì¡A°Ñ¼Æ¥|¡C

    criteria2¬°±ø¥ó2¡A°Ñ¼Æ¤­¡C

    ¨Ï¥Î³o­Ó¤½¦¡¤§«á¡A¤W¤d¤W¸U¦W­û¤uªº¤ë¤u¸ê©M¼úª÷Á`ÃBª÷ÃB¡A¥ß¨è´N³Qºâ¤F¥X¨Ó¡C

    µM«á¡A·¡©¶¤S¨Ï¥Î¤FAVERAGE¨ç¼Æ¡A¨D¥X¤F¨C­Ó¥Ø¼Ð¼Æ¾Úªº¥­§¡­È¡K¡K

    ¤£¤@·|¨à¡A©Ò¦³»Ý­n®Öºâªº¼Æ¾Ú¡A´N¥þ³¡ª½Æ[¦a§e²{¦b¤F²³¤H²´«e¡C

    ¦pªG»¡¤§«e·¡©¶®£©Æªº¥´¦r³t«×¡A¤w¸g²`²`¾_¾Ù¤F¥L­Ì¡C

    ¨º³o¦¸·¡©¶§Q¥Î¨ç¼Æ¤½¦¡¡A§Ö³t®Öºâ¥X¤F©Ò¦³©Ò»Ý¼Æ¾Ú¡A§ó¬Oª½±µ±N¥L­Ì¾_½¦b¦a¡I

    ¡§·¡©¶¡A§A¯u¬O­Ó¤H¤~¡I§â§A¤À°t¨ìºî¦X¤@³B¡A²ª½´N¬O¤W¤Ñªº®¦½ç¡I¡¨

    §d¤j§Ó±q·¥«×¾_Å夤¦^¹L¯«¨Ó¡A¿³¾Ä±o«¢«¢¤j¯º¡A½Ý°_¤j©æ«ü¦j·¡©¶¡C

    ¤£¶È¦p¦¹¡A¥LÁٿ˦۵¹·¡©¶­Ë¤F¤@ªM¤ô¡C

    ¡§¨¯­W¤F¡A¨Ó³ÜªM¤ô¡I¡¨

    ¡§³Bªø¡A³o¥i¨Ï¤£±o¡I¡¨

    ·¡©¶³s¦£Âù¤â±µ¹L·e²¡ªM¡C

    ÁöµM¤º¤ß«Ü²H©w¡A¦ýªí­±¤WÁÙ¬O±o¸Ë¥X¨üÃd­YÅ媺ªí±¡¡A¤£µM¤Ó¤£¦X²z¤F¡C

    ¦¹¨è¥Õ¤å°a¤ß¨½º¡¬O­WÀß¡A¥L¤w¸g¤J¾5¦~¤F¡AÁÙ±q¨S¨É¨ü¹L³oºØ«Ý¹J¡I

    ¡§¥»¥H¬°»Ý­n¤@­Ó¬P´Á¡A¦ý¬O§Ú­Ì¶È¶È¤T­Ó¤p®É´N§Ë¦n¤F¡I¡¨

    §d¤j§Ó»y®ð·¥¨ä¿³¾Ä¦a¹D¡A¡§·¡©¶¡A»°ºò¥´¦L¥X¨Ó§a¡I¡¨

    ¡§¥ý¤£­n«æµÛ¥´¦L¡K¡K¡¨

    ¡§«ç»ò¤F¡H¡¨

    ¡§³oºØ¼Æ¾Ú¬O¨S¦³¸g¹L¥[¤uªº­ì©l¼Æ¾Ú¡A³Ì¦n¤£­nª½±µ®³µ¹»â¾É¬Ý¡I¦]¬°»â¾É¨S¦³¨º»ò¦h®É¶¡¡A³o¥÷­ì©l¼Æ¾Ú´N¹³¬O¼Æ¾Ú®w¡A¦pªG§Ú­Ìµo²{¼Æ¾Ú¥X¤F°ÝÃD¡A¥i¥H±q¼Æ¾Ú®w¨½¬d§äÅçÃÒ¡K¡K¡¨

    ·¡©¶¸ÑÄÀ¹D¡A¡§¦Ó§Ú­Ì¥²¶·¥t¥~¾ã²z¤@¥÷§óª½Æ[²¼äªº¼Æ¾Ú¡AÅý»â¾É¤@¥Ø¤FµM¦a¬Ý¨ì¦Û¤v·Q¬Ý¨ìªº¤º®e¡I¡¨

    µM«á§d¤j§Óµ¥¤H´N¯¸¦b·¡©¶«á­±¡A¬ÝµÛ¥L¨º¨ÇÅý¤H²´ªá·¶Ãªº¼ô½m¾Þ§@¡C

    ¡§¬°¤FÅý¼Æ¾Ú§óª½Æ[¡A§Ú­Ì¥i¥H§â®Öºâ¥X¨Óªº¼Æ¾Ú¥Ñªí®æ¡AÅܦ¨§é½u¹Ï¡B®°§Î¹Ï¡B¬Wª¬¹Ïµ¥¹Ï§Î¡A³o¼Ë»â¾É´N¯à¤@¥Ø¤FµM¦a¬Ý¨ìÃöÁ伯¾Ú¡A¤j¤j¸`¬Ù®É¶¡¡K¡K¡¨

    ¡§¦Ó¥B¤@¨Ç­«­n¼ÐÃD»Ý­n¥[²Ê¡A¥H¬ð¥X¨ä­«­n©Ê,ÁÙ¥i¥H¥[¤WÃC¦â¼Ðª`¡A¥H«K©M¨ä¥L¤º®e¶i¦æ°Ï¤À¡K¡K¡¨

    ¡§¦Ó¥B¡A§Ú­Ì¥i¥H¦b¤@­Óecel¤åÀɤ¤¡A¦h«Ø´X­Óheet¡A¥H«K¦s©ñ¤£¦P¤º®eªº¼Æ¾Ú¡K¡K¡¨

    ¸g¹L·¡©¶¤@³q¾Þ§@¡A¤@¥÷¦UºØ¹Ïªí©M»¡©ú¤å¦r¨Ã­Z¡A¼Æ¾Ú¸Ô¹ê¡AÁÙ¦³Áa¦V¡B¾î¦V¹ï¤ñªº¦Ê¤À¤ñ¼Æ¾Úªº¸ê®Æ¡A¥X²{¦b²³¤H­±«e¡C

    ¡§³Bªø¡A§Aı±o«ç»ò¼Ë¡H¡¨

    ·¡©¶³B²z¦n¤§«á¡A¤£§Ñ¸ß°Ý§d¤j§Óªº·N¨£¡C

    ¡§³o¬O§Ú¨£¹L®æ¦¡³Ì¬üÆ[¡Bªí²{§Î¦¡³Ì°ª®Äªº¼Æ¾Ú¤å½Z¡K¡K¡¨

    §d¤j§Ó§Ô¤£¦íµo¥XÅå¹Ä¡A·í¬Ý¨ì¥´¦L¥X¨Óªº®ÄªG¡A¥L§ó¬O¯º±o¼L³£¦X¤£Ãl¤F¡C

    ¡§¨S·Q¨ì³o¦¸¿ï½Õ¥Í¦Ò¸Õ¡Aµo±¸¤F§A³o»ò­ÓÄ_¨©¡I§Ú¯u¬O¤Ó¶}¤ß¤F¡I¡¨

    ¦A¦¸©ç¤F©ç·¡©¶ªºªÓ»H¡A§d¤j§Óªº²´¯«¨½±»¹¢¤£¦í¦a¬yÅS¥XªY½à¤§¦â¡C

    ¡§¦n¦n¤z¡A«e³~µL¶q°Ú¡I¡¨

    ­±¹ï§d¤j§Óªº¿E¯P¤ÏÀ³¡A·¡©¶¦³¨Ç­ú¯º¤£±o¡C

    Ecel¨ç¼Æ¤½¦¡©M¹Ïªí³B²z§Þ¯à¡A¦b«á¥@³£¬O¦A°ò¦¤£¹Lªº§Þ¯à¡C

    ¦b1999¦~¡A«o¦¨¤F¤H¤H¸r¼}ªº¯Sªø¡I

    §d¤j§Ó®³µÛ¥´¦L¦nªº½Z¤l­·­·¤õ¤õ¦a¨«¥X¤Fºî¦X¤@³Bªº¿ì¤½«Ç¡A­è¦n¦bªù¤f½í¨ì¤FÁú§gÁ{¡C

    Áú§gÁ{¬ÝµÛ¯º±oÁy¤Wªº½K¯¾³£À½¨ì¤F¤@¶ôªº§d¤j§Ó¡A¤£¥Ñ±o·P¨ì¤Q¤ÀºÃ´b¡C

    ¡§¦Ñ§d¡A¤°»ò¨Æ³o»ò°ª¿³¡H¡¨

    ¡§³Bªø¡A§Ú¸ò§A»¡¡A«¥­Ìºî¦X¤@³B³o¦¸¥i¯uºâ¨«¤j¹B¤F¡I¨º­Ó·s¨Óªº¿ï½Õ¥Í·¡©¶¡A²ª½´N¬O­Ó¤Ñ¤~¡A³o¦¸¯uªº¬Oµ¹«¥­Ì°eÄ_¨Ó¤F¡I¡¨

    ¡§³é¨þ¡A¯à±o¨ì§A³o»ò°ªªºµû»ù¥i¤£®e©ö¡A¨º¤p¤lªì¨Ó¥E¨ìªº¡A°µ¤F¤°»òÅý§A³o»ò¬Ý­«¥L¡H¡¨

    §d¤j§Ó³o»ò¤@»¡¡AÁú§gÁ{¤]¨Ó¤F¿³½ì¡C

    §d¤j§Ó¤_¬O±N·¡©¶¥´¦r¶W§Ö¥H¤Î¹q¸£§ï½Z§Þ¯à¸òÁú§gÁ{»¡¤F¤@¤U¡C

    Áú§gÁ{¤@§v´N¨â²´©ñ¥ú¡C

    ¦b1999¦~¡Aºë³q¹q¸£ªººÙ±o¤W¬Oµ}¯Ê¤H¤~¡I

    ³o¬O¥L­Ì³o¤@½ú¤H©Ò¤£¨ã³ÆªºÀu¶Õ¡C

    ¡§½Z¤lµ¹§Ú¬Ý¬Ý¡K¡K¡¨

    Áú§gÁ{²{¦b­¢¤£¤Î«Ý¦a·Q¬Ý¬Ý·¡©¶§ïªº½Z¤l¡C

    ·í¬Ý§¹§d¤j§Ó¤â¨½ªº¥´¦L½Z¤§«á¡AÁú§gÁ{¤]Åܱo±¡ºü¿E°Ê°_¨Ó¡C

    ¡§³oªº½T¬O§Ú¨£¹Lªº±Æª©³Ì¬üÆ[ªº½Z¤l¡A¦Ó¥B¦UºØ¹Ï¼Ð³£ªþ¤W¤F¼Æ¾Ú©M¦Ê¤À¤ñ¡A·¥¨ã»¡ªA¤O¡A¬Û«H¤W­±ªº»â¾É¤]¤@©w·|³ßÅwªº¡I¡¨

    Áú§gÁ{¿E°Ê¤§§E¡A¨I§u¤F¤ù¨è«á¹D¡A¡§³o¼Ë§a¡A¥H«áºî¦X¤@³Bªº¥´¦L½Z³£¥æµ¹·¡©¶­t³d¡A¥Ñ¥L­t³d¾ã²z®æ¦¡¡A³B²z¼Æ¾Ú¡I³o»ò¤@­Ó¤H¤~¡A§Ú­Ì±o¦n¦n§Q¥Î°_¨Ó¡I¡§

    ¡§«¢«¢«¢¡A­^¶¯©Ò¨£²¤¦P¡I§Ú¤]¬O³o»ò·Qªº¡I¡¨

    §d¤j§Ó²n®Ô¦a¤j¯º°_¨Ó¡A·Pı¦Û¤v¦n¤[¨S¦³³o¼Ë¶}¤ß¹L¤F¡C

    ¡§³Bªø¡A¦^¨£«¢¡A§Ú¥ý§â³o¥÷¤å½Z°eµ¹¬Ùªø§å¥Ü¡C¡¨

¥[¤J®Ññ ¤W¤@³¹ ¥Ø ¿ý ¤U¤@³¹ ¥[¤J®Ñ¬[ ±ÀÂË¥»®Ñ

¦pªG±z³ßÅw,½Ð§â¡m­«¥Í©x�õ¬x_§½ªï°ù°Æ¬Ù¤dª÷¡n,¤è«K¥H«á¾\Ū­«¥Í©x�õ¬x_§½ªï°ù°Æ¬Ù¤dª÷²Ä34³¹ µ}¯Ê¤H¤~¡I«áªº§ó·s³s¸ü!
¦pªG§A¹ï­«¥Í©x�õ¬x_§½ªï°ù°Æ¬Ù¤dª÷²Ä34³¹ µ}¯Ê¤H¤~¡I¨Ã¹ï­«¥Í©x�õ¬x_§½ªï°ù°Æ¬Ù¤dª÷³¹¸`¦³¤°»ò«ØÄ³©ÎªÌµû½×¡A½Ð«á¥xµo«H®§µ¹ºÞ²z­û¡C