{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Arial;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue255;\red128\green128\blue128;}{\stylesheet {\style\s0 \ql\fi0\li0\ri0\f1\fs24\cf0 Normal;}{\style\s3 \ql\fi0\li0\ri0\f1\fs26\b\cf0 heading 3;}{\style\s2 \ql\fi0\li0\ri0\f1\fs28\b\i\cf0 heading 2;}{\style\s1 \ql\fi0\li0\ri0\f1\fs32\b\cf0 heading 1;}}{\*\listtable}{\*\listoverridetable}{\*\generator iText 2.1.5 (by lowagie.com)}{\info}\paperw11907\paperh16840\margl720\margr720\margt720\margb720{\footer \pard\plain\s0\qc\fi0\li0\ri0\sl320\plain\f0\fs18 \u31532?\f0{\field{\*\fldinst PAGE}{\fldrslt  }}\f0\fs18 \u-26507?\par}{\header \pard\plain\s0\qr\fi0\li0\ri0\sl320\plain\f0\fs18 \u21517?\u24072?\u-29774?\u25480?\u183?\u20248?\u-29400?\u-29698?\u31243?\u8212?\u8212?\u21517?\u-29698?\u22530?\par}\pgwsxn11907\pghsxn16840\marglsxn720\margrsxn720\margtsxn720\margbsxn720\pard\plain\s0\qc\fi0\li0\ri0\sa140\plain\f0\fs36\b \u25581?\u26195?\u-29406?\u21153?\u25968?\u25454?\u23494?\u30721?\u-230?\u26234?\u-32515?Excel\u24314?\u27169?\u19982?\u20998?\u26512?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT054470\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u21517?\u31216?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/054470.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u25581?\u26195?\u-29406?\u21153?\u25968?\u25454?\u23494?\u30721?\u-230?\u26234?\u-32515?Excel\u24314?\u27169?\u19982?\u20998?\u26512?\ul0 }}\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u25152?\u23646?\u31867?\u21035?\u12305?\u-230?\u-29406?\u21153?\u31649?\u29702?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u24320?\u-29698?\u26102?\u-27148?\u12305?\u-230?2025\u24180?10\u26376?30\u26085? \u21040? 2025\u24180?10\u26376?30\u26085? \u19978?\u28023? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?11\u26376?14\u26085? \u21040? 2024\u24180?11\u26376?14\u26085? \u19978?\u28023? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2023\u24180?11\u26376?30\u26085? \u21040? 2023\u24180?11\u26376?30\u26085? \u19978?\u28023? 2800\u20803?/\u20301?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u-29708?\u26126?\u12305?\u-230?\u26412?\u22521?\u-29779?\u-29698?\u31243?\u20840?\u24180?\u24490?\u29615?\u24320?\u-29698?\u-244?\u22914?\u26377?\u-26880?\u27714?\u-244?\u27426?\u-28722?\u26469?\u30005?\u21672?\u-29726?\u-255?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u20854?\u20182?\u24320?\u-29698?\u22478?\u24066?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/054470.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u19978?\u28023?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk4/032905.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u31119?\u24030?\ul0 }}\f0\fs22  \par\pard\plain\s0\fi0\li0\ri0\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?\u-29406?\u21153?\u25968?\u25454? Excel\u24314?\u27169?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u-32564?\u26223?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23545?\u20110?\u-29406?\u21153?\u26469?\u-29708?\u-244?\u27599?\u20010?\u26376?\u-28419?\u-30335?\u-26782?\u23545?\u22823?\u-28209?\u32321?\u26434?\u30340?\u-29406?\u21153?\u25968?\u25454?\u-244?\u25968?\u25454?\u32463?\u-28729?\u32321?\u22797?\u30340?\u25972?\u29702?\u12289?\u-29791?\u31639?\u12289?\u20998?\u26512?\u12289?\u21046?\u22270?\u31561?\u19968?\u31995?\u21015?\u24037?\u20316?\u-244?\u25165?\u-32515?\u26368?\u32456?\u23637?\u29616?\u20854?\u-32564?\u21518?\u30340?\u25968?\u25454?\u-28613?\u-28783?\u12290?\u22312?\u27492?\u-28729?\u31243?\u20013?\u-244?\u-29406?\u21153?\u20154?\u21592?\u26082?\u-26880?\u-30335?\u25968?\u25454?\u24605?\u32500?\u-244?\u21448?\u-26880?\u-30335?Excel\u25216?\u-32515?\u-244?\u20004?\u-32763?\u32570?\u19968?\u19981?\u21487?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u28982?\u-32756?\u-244?\u24456?\u22810?\u-29406?\u21153?\u20154?\u21592?\u22312?\u23454?\u-27067?\u24037?\u20316?\u20013?\u-244?\u20250?\u-26782?\u20020?\u20197?\u19979?\u22256?\u24785?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u8722? \u24456?\u22810?\u-30616?\u21333?\u30340?\u25968?\u25454?\u-28209?\u22823?\u12289?\u30011?\u-26782?\u24863?\u24046?\u-244?\u19981?\u21516?\u30340?\u25968?\u25454?\u24590?\u20040?\u-28663?\u25321?\u26368?\u-28670?\u21512?\u30340?\u22270?\u-30616?\u23637?\u31034?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u8722? \u-28709?\u-30644?\u-29406?\u21153?\u20998?\u26512?\u26102?\u-244?\u-29723?\u29992?\u20160?\u20040?\u20998?\u26512?\u26041?\u27861?\u21644?\u24605?\u-29201?\u26469?\u-28709?\u-30644?\u27719?\u24635?\u21644?\u25552?\u28860?\u-244?\u-29783?\u20998?\u26512?\u32467?\u26524?\u19968?\u30446?\u20102?\u28982?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u8722? \u-32767?\u26495?\u24819?\u30475?\u24471?\u-29406?\u21153?\u25968?\u25454?\u31350?\u31455?\u26377?\u21738?\u20123?\u-225?\u22914?\u20309?\u-29783?\u-29406?\u21153?\u27719?\u25253?\u31616?\u27905?\u12289?\u28165?\u26224?\u12289?\u30452?\u20987?\u30171?\u28857?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20026?\u20102?\u-29783?\u-29406?\u21153?\u20154?\u21592?\u20174?\u32321?\u-28211?\u-32756?\u-28211?\u22797?\u24615?\u-25896?\u30340?\u25968?\u25454?\u20013?\u25277?\u-29013?\u-244?\u-29783?\u-29406?\u21153?\u25253?\u21578?\u30452?\u-30270?\u26377?\u25928?\u-244?\u26412?\u27425?\u12298?\u25581?\u26195?\u-29406?\u21153?\u25968?\u25454?\u23494?\u30721?\u-230?\u26234?\u-32515?Excel\u24314?\u27169?\u19982?\u20998?\u26512?\u12299?\u20174?\u23454?\u-27067?\u26696?\u20363?\u20837?\u25163?\u-244?\u25226?\u20174?\u25968?\u25454?\u25972?\u29702?\u21040?\u20998?\u26512?\u30340?\u24605?\u-32765?\u-28729?\u31243?\u21644?\u21046?\u20316?\u-28729?\u31243?\u-28709?\u-30644?\u-29722?\u32454?\u30340?\u-29774?\u-30237?\u-244?\u24341?\u23548?\u23398?\u21592?\u22312?\u23398?\u20250?\u21152?\u24037?\u22788?\u29702?\u25968?\u25454?\u30340?\u22522?\u30784?\u19978?\u-244?\u25484?\u25569?\u22914?\u20309?\u25226?\u32479?\u-29791?\u32467?\u26524?\u29992?\u-29715?\u-30208?\u25991?\u23383?\u30340?\u26041?\u24335?\u-28781?\u20986?\u-244?\u23398?\u20250?\u-30237?\u-29701?\u25968?\u25454?\u-32564?\u21518?\u30340?\u20449?\u24687?\u12289?\u23618?\u23618?\u-28654?\u-28709?\u26597?\u25214?\u-27154?\u-26472?\u30340?\u26681?\u28304?\u-244?\u20026?\u20225?\u19994?\u-29406?\u21153?\u31649?\u29702?\u12289?\u32463?\u-31707?\u20915?\u31574?\u25552?\u20379?\u23454?\u26102?\u26234?\u-32515?\u25903?\u25345?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u29305?\u-32142?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u-29406?\u21153?\u19987?\u23646?\u12305?Excel\u30340?\u31934?\u21326?\u24212?\u29992?\u-244?\u-30835?\u21512?25\u24180?+\u-29406?\u21153?\u32463?\u-25972?\u-244?\u-30237?\u-29701?\u32479?\u-29791?\u32467?\u26524?\u-244?\u-28781?\u20986?\u-29406?\u21153?\u-29715?\u-30208?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u-32515?\u21147?\u25552?\u21319?\u12305?\u-28646?\u-28729?\u29616?\u22330?\u28436?\u32451?\u20989?\u25968?\u12289?\u22270?\u24418?\u21040?\u21160?\u24577?\u27169?\u22411?\u-244?\u25552?\u21319?\u25968?\u25454?\u24314?\u27169?\u12289?\u25968?\u25454?\u20998?\u26512?\u32508?\u21512?\u27700?\u24179?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u23398?\u20197?\u-32268?\u29992?\u12305?\u-28545?\u24320?\u32431?\u25216?\u26415?\u24615?\u-29774?\u-30237?\u-244?\u30495?\u23454?\u26696?\u20363?\u24341?\u21457?\u23398?\u21592?\u24037?\u20316?\u-32684?\u24819?\u-244?\u-29698?\u21518?\u29087?\u32451?\u-28720?\u29992?\u20110?\u24037?\u20316?\u20013?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u20869?\u23481?\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19968? \u24212?\u29992?offset\u20989?\u25968?\u-244?\u-28805?\u26494?get\u21160?\u24577?\u22270?\u-30616?\u-244?\u24555?\u-28641?\u32479?\u-29791?\u20998?\u26512?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?offset\u20989?\u25968?\u21015?\u25968?\u25454?\u-28820?\u25442?\u25104?\u-30644?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u23558?\u19968?\u21015?\u25968?\u25454?\u-28820?\u25442?\u25104?\u19968?\u-30644?\u-244?\u-28217?\u29992?\u22797?\u21046?\u-28663?\u25321?\u24615?\u31896?\u-29388?\u-244?\u-28663?\u-28820?\u32622?\u30340?\u26041?\u27861?\u23601?\u-32515?\u23454?\u29616?\u-244?\u-32756?\u26377?\u20123?\u22330?\u26223?\u19979?\u19981?\u-28670?\u21512?\u22797?\u21046?\u31896?\u-29388?\u-244?\u24076?\u26395?\u-28646?\u-28729?\u32534?\u20889?\u20844?\u24335?\u23454?\u29616?\u-28820?\u32622?\u-244?offset\u20989?\u25968?\u26159?\u-26218?\u-28663?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?offset\u20989?\u25968?\u-29693?\u29992?\u21015?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22312?\u21046?\u20316?\u21160?\u24577?\u22270?\u-30616?\u26102?\u-244?\u-26880?\u-30335?\u21160?\u24577?\u-29693?\u21462?\u-30616?\u20013?\u30340?\u25968?\u25454?\u20379?\u22270?\u-30616?\u20351?\u29992?\u-244?\u-28217?\u29992?offset\u32534?\u20889?\u20844?\u24335?\u26159?\u26368?\u24120?\u29992?\u30340?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?offset\u20989?\u25968?\u-29693?\u29992?\u21015?\u25968?\u25454?\u23454?\u25112?\u22330?\u26223?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21033?\u29992?\u25511?\u20214?\u21644?offset\u20989?\u25968?\u-28805?\u26494?\u23454?\u29616?\u21160?\u24577?\u22270?\u-30616?\u21151?\u-32515?\u-244?\u26041?\u27861?\u31616?\u20415?\u-244?\u23481?\u26131?\u19978?\u25163?\u-244?\u30475?\u20284?\u22797?\u26434?\u30340?\u25928?\u26524?\u25805?\u20316?\u26041?\u27861?\u21364?\u24456?\u31616?\u21333?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?offset\u20989?\u25968?\u23454?\u25112?\u24212?\u29992?\u20043?\u25209?\u-28209?\u32479?\u-29791?\u21608?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24037?\u20316?\u20013?\u32463?\u24120?\u-26880?\u-30335?\u25353?\u29031?\u19981?\u21516?\u32479?\u-29791?\u21475?\u24452?\u23545?\u25968?\u25454?\u27714?\u21644?\u-244?\u26377?\u25353?\u26376?\u27714?\u21644?\u-244?\u-28712?\u26377?\u25353?\u21608?\u27714?\u21644?\u-244?\u26412?\u26696?\u20363?\u25552?\u20379?\u19968?\u20010?\u20415?\u25463?\u26041?\u27861?\u-244?\u24555?\u-28641?\u-29791?\u31639?\u20986?\u27599?\u21608?\u30340?\u25968?\u25454?\u20043?\u21644?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?offset\u20989?\u25968?\u20043?\u24494?\u20449?\u25509?\u-24679?\u26684?\u24335?\u-28820?\u25442?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24494?\u20449?\u25509?\u-24679?\u25105?\u20204?\u-28419?\u29992?\u-28729?\u-244?\u24403?\u-26880?\u-30335?\u32479?\u-29791?\u26102?\u25165?\u21457?\u29616?\u24494?\u20449?\u25509?\u-24679?\u20986?\u26469?\u30340?\u20869?\u23481?\u24456?\u-26946?\u32479?\u-29791?\u-29791?\u31639?\u-244?\u26412?\u-32126?\u20869?\u23481?\u25552?\u20379?\u19968?\u20010?\u31616?\u21333?\u30340?\u26041?\u27861?\u-244?\u23558?\u25509?\u-24679?\u30340?\u20869?\u23481?\u24555?\u-28641?\u-28820?\u25442?\u20026?\u20415?\u20110?\u32479?\u-29791?\u-29791?\u31639?\u30340?\u26684?\u24335?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?offset\u20989?\u25968?\u32508?\u21512?\u23454?\u25112?\u24212?\u29992?\u-27392?\u21806?\u25968?\u25454?\u21160?\u24577?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u32467?\u21512?\u21160?\u24577?\u22270?\u-30616?\u23454?\u25112?\u26696?\u20363?\u-244?\u25226?\u19978?\u-28688?\u20171?\u32461?\u21040?\u30340?\u20960?\u20010?\u25216?\u24039?\u-30835?\u20837?\u23454?\u25112?\u26696?\u20363?\u20013?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u12289?offset\u20989?\u25968?\u21160?\u24577?\u20998?\u26512?\u-28795?\u21161?\u25216?\u-32515?\u20043?\u26465?\u20214?\u26684?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26465?\u20214?\u26684?\u24335?\u22312?\u21160?\u24577?\u22270?\u-30616?\u12289?\u25968?\u25454?\u24314?\u27169?\u20013?\u26377?\u30528?\u19981?\u21487?\u26367?\u20195?\u30340?\u20316?\u29992?\u-244?\u22823?\u22823?\u25552?\u-25896?\u20102?\u22270?\u-30616?\u30340?\u-30270?\u-29361?\u24615?\u-244?\u26356?\u30452?\u-30270?\u12289?\u26356?\u26174?\u-31657?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8\u12289?offset\u20989?\u25968?\u23454?\u25112?\u24212?\u29992?\u-27392?\u21806?\u23545?\u27604?\u23458?\u27969?\u-29301?\u21183?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u32467?\u21512?\u19968?\u27454?\u23454?\u25112?\u26696?\u20363?\u-244?\u23558?\u20004?\u32452?\u19981?\u21516?\u25968?\u-28209?\u32423?\u30340?\u25968?\u25454?\u25972?\u21512?\u22312?\u19968?\u24352?\u22270?\u-30616?\u20013?\u12290?\u24037?\u20316?\u20013?\u32463?\u24120?\u-26880?\u-30335?\u25226?\u20154?\u25968?\u21644?\u-27392?\u-28209?\u-244?\u25110?\u-32763?\u25226?\u-27392?\u-28209?\u21644?\u-27392?\u21806?\u-26467?\u25918?\u-28709?\u19968?\u24352?\u22270?\u-30616?\u20013?\u12290?\u30001?\u20110?\u20004?\u32452?\u25968?\u25454?\u30340?\u25968?\u-28209?\u32423?\u24046?\u-29219?\u-28797?\u22823?\u-244?\u20351?\u24471?\u25968?\u-28209?\u32423?\u-28797?\u23567?\u30340?\u22270?\u-30616?\u20960?\u20046?\u30475?\u19981?\u21040?\u12290?\u26412?\u-32126?\u20869?\u23481?\u23558?\u-29722?\u32454?\u-29774?\u-30237?\u19981?\u21516?\u25968?\u-28209?\u32423?\u25968?\u25454?\u21046?\u20316?\u22270?\u-30616?\u30340?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20108? \u25968?\u25454?\u27719?\u24635?\u26377?\u22937?\u25307?\u-230?sumifs & sumproduct \u21508?\u31867?\u29992?\u27861?\u20840?\u25915?\u30053?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u21333?\u26465?\u20214?\u27714?\u21644?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20998?\u31867?\u27714?\u21644?\u22312?\u-29406?\u21153?\u24037?\u20316?\u20013?\u30340?\u29992?\u-28652?\u26368?\u20026?\u24191?\u27867?\u-244?\u26377?\u25353?\u26376?\u27719?\u24635?\u12289?\u25353?\u-28440?\u-27160?\u27719?\u24635?\u12289?\u25353?\u20135?\u21697?\u27719?\u24635?\u12289?\u25353?\u23458?\u25143?\u27719?\u24635?\u12289?\u25353?\u19994?\u21153?\u21592?\u27719?\u24635?\u31561?\u31561?\u-244?\u26377?\u30340?\u-28712?\u-26880?\u-30335?\u21508?\u31181?\u26465?\u20214?\u32452?\u21512?\u27719?\u24635?\u12290?\u26368?\u24120?\u-30271?\u30340?\u26041?\u27861?\u26159?\u20351?\u29992?sumif\u20989?\u25968?\u-244?\u22312?\u20351?\u29992?\u20013?\u20250?\u-28601?\u21040?\u21508?\u31181?\u-27154?\u-26472?\u-244?\u20363?\u22914?\u-26880?\u-30335?\u28155?\u21152?\u-28795?\u21161?\u21015?\u25552?\u21462?\u26376?\u20221?\u21518?\u25165?\u-32515?\u23545?\u26376?\u20221?\u27714?\u21644?\u31561?\u12290?\u-28711?\u20123?\u-27154?\u-26472?\u20250?\u22312?\u19979?\u-26782?\u30340?\u20869?\u23481?\u20013?\u-28656?\u20010?\u20171?\u32461?\u-244?\u26412?\u-32126?\u20869?\u23481?\u20026?\u21333?\u26465?\u20214?\u27714?\u21644?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u22810?\u26465?\u20214?\u27714?\u21644?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-32126?\u20869?\u23481?\u20171?\u32461?\u22810?\u20010?\u32452?\u21512?\u26465?\u20214?\u19979?\u32534?\u20889?\u20844?\u24335?\u30340?\u26041?\u27861?\u21644?\u27880?\u24847?\u20107?\u-26503?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u25552?\u21462?\u26085?\u26399?\u20013?\u30340?\u26376?\u20221?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22312?\u19981?\u20511?\u21161?\u-28795?\u21161?\u21015?\u25552?\u21462?\u26376?\u20221?\u30340?\u21069?\u25552?\u19979?\u-244?\u-32515?\u21542?\u20998?\u26376?\u27714?\u21644?\u12290?\u26412?\u-32126?\u-29698?\u31243?\u20171?\u32461?sumproduct\u20989?\u25968?\u30340?\u25552?\u21462?\u26376?\u20221?\u30340?\u29420?\u29305?\u29992?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u25972?\u21015?\u25968?\u25454?\u21306?\u22495?\u30340?\u19981?\u21516?\u29992?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Sumifs\u19982?sumproduct\u20989?\u25968?\u22312?\u20351?\u29992?\u26041?\u27861?\u19978?\u30340?\u30456?\u21516?\u28857?\u21644?\u19981?\u21516?\u28857?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u19981?\u-30268?\u-31997?\u25968?\u25454?\u30340?\u22788?\u29702?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20174?\u21508?\u31867?\u-28817?\u20214?\u23548?\u20986?\u26469?\u30340?\u25968?\u25454?\u22312?\u-28709?\u-30644?\u20998?\u31867?\u27714?\u21644?\u26102?\u20250?\u20986?\u29616?\u21508?\u31181?\u21508?\u26679?\u30340?\u-27367?\u-29713?\u-244?\u26412?\u-32126?\u20869?\u23481?\u20171?\u32461?\u20986?\u29616?\u-27367?\u-29713?\u26102?\u24039?\u22937?\u24212?\u23545?\u30340?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u22810?\u21306?\u22495?\u25968?\u25454?\u27714?\u21644?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20998?\u31867?\u27714?\u21644?\u19968?\u-32212?\u21482?\u-27512?\u23545?\u19968?\u21015?\u25968?\u25454?\u27714?\u21644?\u-244?\u22914?\u26524?\u21516?\u26102?\u23545?\u22810?\u21015?\u25968?\u25454?\u27714?\u21644?\u20351?\u29992?sumifs\u20989?\u25968?\u26080?\u27861?\u23454?\u29616?\u-244?\u-32756?\u-28217?\u29992?sumproduct\u20989?\u25968?\u-32515?\u-28805?\u26494?\u23436?\u25104?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u12289?\u20998?\u31867?\u27714?\u21644?\u20043?\u-28719?\u20284?\u21305?\u-28339?\u25110?\u27169?\u31946?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20998?\u31867?\u27719?\u24635?\u30340?\u25351?\u23450?\u26465?\u20214?\u19968?\u-32212?\u-28419?\u26159?\u-26786?\u24120?\u30830?\u23450?\u30340?\u-244?\u20294?\u26377?\u26102?\u20063?\u23384?\u22312?\u-28719?\u20284?\u26465?\u20214?\u30340?\u21305?\u-28339?\u-244?\u20363?\u22914?\u-29791?\u31639?\u21253?\u21547?\u8220?\u26576?\u26576?\u20135?\u21697?\u8221?\u30340?\u25968?\u25454?\u20043?\u21644?\u-244?\u-28211?\u28857?\u22312?\u20110?\u19981?\u26159?\u31561?\u20110?\u19968?\u20010?\u25351?\u23450?\u20869?\u23481?\u-244?\u-32756?\u26159?\u21253?\u21547?\u25351?\u23450?\u20869?\u23481?\u-244?\u26412?\u-32126?\u20869?\u23481?\u20171?\u32461?sumifs\u20989?\u25968?\u22312?\u-28719?\u20284?\u21305?\u-28339?\u25110?\u31216?\u27169?\u31946?\u21305?\u-28339?\u20013?\u30340?\u24212?\u29992?\u25216?\u24039?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19977? \u23454?\u25112?\u24212?\u29992?\u-230?\u25968?\u25454?\u32508?\u21512?\u20998?\u26512?&\u-29715?\u-30208?\u25991?\u23383?\u21576?\u29616?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u-29406?\u21153?\u25253?\u-30616?\u32508?\u21512?\u20998?\u26512?\u31995?\u32479?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-32126?\u20869?\u23481?\u26159?\u26412?\u26399?\u30340?\u-28211?\u28857?\u26696?\u20363?\u-244?\u20197?\u24180?\u32456?\u-29406?\u21153?\u32508?\u21512?\u20998?\u26512?\u20026?\u-32564?\u26223?\u-244?\u-29762?\u-29791?\u20102?\u19977?\u32452?\u19981?\u21516?\u30340?\u25968?\u25454?\u-244?\u24182?\u26681?\u25454?\u19981?\u21516?\u25968?\u25454?\u24320?\u23637?\u20998?\u26512?\u-244?\u20174?\u25343?\u21040?\u-27154?\u-26472?\u24320?\u22987?\u-244?\u25226?\u-29762?\u-29791?\u-28729?\u31243?\u12289?\u23454?\u29616?\u-28729?\u31243?\u19968?\u19968?\u-29774?\u-30237?\u28165?\u26970?\u-244?\u20146?\u-29013?\u32463?\u21382?\u19968?\u27425?\u24180?\u32456?\u30340?\u-29406?\u21153?\u32508?\u21512?\u20998?\u26512?\u30340?\u21046?\u20316?\u-28729?\u31243?\u-244?\u24341?\u23548?\u23398?\u21592?\u22914?\u20309?\u24605?\u-32765?\u12289?\u-29762?\u-29791?\u20998?\u26512?\u27969?\u31243?\u-244?\u22914?\u20309?\u25226?\u25569?\u25972?\u20307?\u12289?\u25511?\u21046?\u32454?\u-32126?\u12290?\u20854?\u20013?\u26082?\u26377?excel\u30693?\u-29754?\u28857?\u30340?\u24212?\u29992?\u25216?\u24039?\u-244?\u26356?\u26377?\u-29406?\u21153?\u24605?\u32500?\u12289?\u-32767?\u26495?\u24605?\u32500?\u-29393?\u24443?\u20854?\u20013?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u22914?\u20309?\u25226?\u25968?\u25454?\u20998?\u26512?\u32467?\u26524?\u-28820?\u21270?\u25104?\u25991?\u23383?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-32126?\u20869?\u23481?\u30340?\u32032?\u26448?\u21462?\u-32278?\u25130?\u-32269?8\u26376?\u26411?\u20840?\u22269?\u21508?\u22823?\u27773?\u-28826?\u21378?\u21830?\u27773?\u-28826?\u25209?\u21457?\u-27392?\u21806?\u25968?\u25454?\u25490?\u-30644?\u27036?\u-244?\u20174?\u-28711?\u20123?\u25968?\u25454?\u20013?\u22914?\u20309?\u-30237?\u-29701?\u12289?\u20171?\u32461?\u-244?\u22914?\u20309?\u31361?\u20986?\u-28211?\u28857?\u12289?\u-30616?\u-28738?\u20542?\u21521?\u24615?\u-225?\u26412?\u-32126?\u20869?\u23481?\u-28663?\u21462?\u20102?\u22269?\u20869?\u26576?\u30693?\u21517?app\u24179?\u21488?\u30340?\u19968?\u27573?\u25991?\u23383?\u32508?\u-28688?\u-244?\u21033?\u29992?\u-28711?\u27573?\u32508?\u-28688?\u25991?\u31456?\u21078?\u26512?\u27599?\u20010?\u27573?\u-31683?\u30340?\u20316?\u29992?\u-244?\u-29774?\u-30237?\u21069?\u21518?\u20869?\u23481?\u30340?\u-29762?\u-29791?\u29702?\u24565?\u-244?\u20197?\u21450?\u20998?\u26512?\u26041?\u27861?\u30340?\u24402?\u32435?\u24615?\u24635?\u32467?\u-244?\u19968?\u23450?\u-32515?\u-29783?\u20320?\u-32717?\u30446?\u19968?\u26032?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-28435?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 25\u24180?+\u20844?\u21496?\u-29406?\u21153?\u24635?\u30417?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29774?\u24072?\u31616?\u20171?\u-230?\u-28435?\u-32767?\u24072?\u30446?\u21069?\u29616?\u20219?\u20844?\u21496?\u-29406?\u21153?\u24635?\u30417?\u-244?\u26377?\u-29307?\u-28729?25\u24180?\u-29406?\u21153?\u24037?\u20316?\u32463?\u-25972?\u-244?20\u24180?EXCEL\u23398?\u20064?\u22521?\u-29779?\u32463?\u21382?\u-244?\u21382?\u20219?\u25104?\u26412?\u20250?\u-29791?\u12289?\u20250?\u-29791?\u20027?\u31649?\u12289?\u-29406?\u21153?\u32463?\u29702?\u12289?\u-29406?\u21153?\u21103?\u24635?\u30417?\u12289?\u-29406?\u21153?\u24635?\u30417?\u-244?\u20855?\u26377?\u20016?\u23500?\u30340?\u-29406?\u21153?\u23454?\u25112?\u32463?\u-25972?\u12290?\u23545?\u20110?EXCEL\u12289?ACCESS\u12289?\u-28207?\u-30858?BOS\u24179?\u21488?\u31561?\u25968?\u25454?\u31649?\u29702?\u-28817?\u20214?\u-28419?\u-32515?\u29087?\u32451?\u24212?\u29992?\u12290?\u21892?\u20110?\u25968?\u23383?\u22788?\u29702?\u21644?\u25968?\u25454?\u20998?\u26512?\u-244?\u20174?\u25968?\u25454?\u-30254?\u24230?\u23545?\u-29406?\u21153?\u31649?\u29702?\u21644?\u20225?\u19994?\u31649?\u29702?\u26377?\u29420?\u29305?\u30340?\u-30271?\u-30237?\u12290?\u22312?\u22521?\u-29779?\u20013?\u21892?\u20110?\u25226?\u22797?\u26434?\u-27154?\u-26472?\u31616?\u21333?\u21270?\u-244?\u29992?\u24418?\u-29599?\u30340?\u22270?\u25991?\u26041?\u24335?\u-29783?\u23398?\u21592?\u29282?\u-29776?\u21508?\u31181?\u30693?\u-29754?\u-244?\u23545?\u25968?\u25454?\u31649?\u29702?\u26377?\u30528?\u25935?\u-27376?\u30340?\u27934?\u23519?\u21147?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par}