ࡱ> @ Q0bjbjFF "x,,Q(,,,,,,nj-l`/`/`/`/;0;0;0*n,n,n,n,n,n,n$pRgrPn>3;0;0>3>3Pn`/`/en333>3"`/`/*n3>3*n33Zj`/- P oSR,`3R`j$jD{n0nj$s3sHjj"sj;00r3M1\1;0;0;0PnPn3 Count and Sum Your Data in Excel 2002Formulas for the Arsenal of Every Excel User INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET  INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET Posted: October 16, 2002  INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET Related Links  INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/arrow_default.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/reLink2.gif" \* MERGEFORMATINET   HYPERLINK "http://www.microsoft.com/office/previous/xp/columns/default.asp" Find other expert columns about Office  INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET   INCLUDEPICTURE "http://www.microsoft.com/products/shared/images/ts.gif" \* MERGEFORMATINET  By John Walkenbach, Microsoft Most Valuable Professional (MVP) Counting and summing are basic spreadsheet operations and they can go a long way to helping you get the most out of Microsoft Excel version 2002. The summing and counting formulas in this article should be in the arsenal of every Excel user. The formulas are based on the worksheet in Figure 1. The 12 data rows in Figure 1 contain sales information for an average company, and consist of three fields: the sales representative, month of the sale, and amount of the sale. The examples of summing and counting formulas will demonstrate how a small company could analyze this data. Your data may more extensive and collected for different purposes, but the formulas will work just the same. After explaining the example formulas, we provide the result of the formulas based on the data in Figure 1.  INCLUDEPICTURE "http://www.microsoft.com/office/previous/xp/columns/images/img_excelgraph.gif" \* MERGEFORMATINET  Figure 1: Sample Excel worksheet Summing and Counting Getting the sum of numbersbe if for your budget, sales statistics, or inventoryis a common task. Use the SUM function in these instances. These formulas return the sum of the numbers in the C column: Add values within a certain range: =SUM(C2:C13) Formula result: 6,125 Add values for an entire range: =SUM(C:C). New data is often added to an existing table, so the number of rows will vary. This formula adds up the entire column and eliminates the need to edit your formula when new data is inserted. For counting values, use the COUNT function. It returns the number of values in a range and can quickly determine how many cells contain numeric information. This can be helpful, for example, when trying to determine how many months had sales. Count values in a range: =COUNT(C2:C13) Formula result: 12 Count values in the entire range: =COUNT(C:C) Although column C contains 13 entries, these formulas return 12 because the COUNT function only counts numeric values. If you need to count all the cells in a range that contain any information, use the COUNTA function, such as: =COUNTA(A:A). This formula will return a result of 13. Conditional Counting and Summing Using a Single Condition In many cases, you don't want to count or sum all of the records. Rather, you want to focus on records that meet a certain condition, for example, only the sales made by a sales representative. Use the COUNTIF and SUMIF functions to return these types of results. Count the Number of Sales Made by a Sales Representative The following formula is a straightforward use of the COUNTIF function. It counts the sales made by Jones: =COUNTIF(A2:A13,"Jones") Formula result: 4 You can also write this formula as: =COUNTIF(A2:A13,"=Jones"). If a comparison operator is omitted, Excel assumes "equal to." Count the Number of Sales Made by Other Sales Representatives This formula counts all the sales not made by Jones: =COUNTIF(A2:A13,"<>Jones") Formula result: 8 Count the Number of Sales Greater than a Target Value This formula counts the number of sales in C2:C13 that are greater than a target value. In this example, the target value would have to be entered into D1. This COUNTIF function accepts a cell reference in the second argument. Also, notice that this formula uses the concatenation operator (&) to join the greater than symbol (>) with the cell reference. =COUNTIF(C2:C13,">"&D1) Count the Number of Sales Greater than the Sales Average This formula returns the number of sales that exceed the average sales amount. This formula also shows that you can use a function as the second argument for COUNTIF: =COUNTIF(C2:C13,">"&AVERAGE(C2:C13)) Formula result: 5 Conditional Summing The SUMIF function is similar to COUNTIF, but it uses an additional argument. The first argument refers to the range that is being evaluated, the second argument represents the criteria, and the third argument is the range to be summed. Add Up Sales in a Given Month This formula adds up all the sales in January: =SUMIF(B2:B13,"=Jan",C2:C13) Formula result: 1,925 As with the COUNTIF function, an "equal to" condition is assumed if the comparison operator is omitted. The preceding formula could have been written as: =SUMIF(B2:B13,"=Jan",C2:C13). Add Up Sales Made by Other Sales Representatives This formula adds up the sales made by sales representatives other than Rogers. It uses a "not equal to" comparison: =SUMIF(A2:A13,"<>Rogers",C2:C13) Formula result: 4,425 Add Up the Sales Greater than a Certain Value This formula adds up all the values that are greater than 500. In this formula, the condition being evaluated is based on the same range that is being summed: =SUMIF(C2:C13,">500",C2:C13) Formula result: 4,450 Note: The COUNTIF and SUMIF functions can also use wildcard comparison characters. For more information, in Excel Help search for "wildcard." Conditional Counting and Summing Using Multiple Conditions The formulas in the section return counts or sums based on two or more conditions. Count the Number of Months a Sales Representative Made a Sale This formula counts the number of times Jones made sales in February. It is a conditional counting formula that uses two conditions. =SUMPRODUCT((A2:A13="Jones")*(B2:B13="Feb")) Formula result: 2 Table 1 shows what's going on behind the scenes. The first column shows the result of the first part of the argument. The second column shows the result of the second part of the argument. The last column shows the result of multiplying the first two columns. When both columns are TRUE, the result of multiplying similar values is 1. The formula then returns the sum of these multiplications. A2:A13="Jones" B2:B13="Feb" Result of multiplication True False 0 True False 0 False False 0 False False 0 False False 0 False False 0 False True 0 True True 1 False True 0 False True 0 False True 0 True True 1 Table 1 Count Months When Sales Are Greater than a Specific Amount You can use a formula similar to the one above to work with numeric data. This formula returns the number of rows in which the month is January and the amount is greater than 200. =SUMPRODUCT((B2:B13="Jan")*(C2:C13>200)) Formula result: 4 Count the Number of Sales that Are Between Specific Values This formula counts the number of times the sales amount falls between two 200 and 500. The formula uses two conditions: the amount greater than or equal to 200, and the amount less than or equal to 500. =SUMPRODUCT((C2:C13>=200)*(C2:C13<=500)) Formula result: 5 Count the Number of Sales Based on Three Conditions This formula returns the amount when the sales representative is Jones, the month is February, and the amount is greater than 500. This function uses a single argument, which consists of three logical expressions multiplied together. The result is the sum of these products. =SUMPRODUCT((A2:A13="Jones")*(B2:B13="Feb")*(C2:C13>500)) Formula result: 1 Add Up a Representatives Sales in One Month The formula below adds up sales amount based on two conditions: when the sales representative is Jones and the month is February. =SUMPRODUCT((A2:A13="Jones")*(B2:B13="Feb")*(C2:C13)) Formula result: 1,150 Add the Combined Sales for Two Sales Representatives The formula below returns the sum of the sales amount for both Jones and Rogers. This formula uses a single argument and consists of three expressions. Notice, however, that the first two arguments are not multiplied as in the previous examples. Because we are doing a logical OR comparison, they are summed. Summing two logical values results in a value of 1 when either of the expressions is TRUE. =SUMPRODUCT(((A2:A13="Jones")+(A2:A13="Rogers"))*(C2:C13)) Formula result: 3,175 Want More? This article can not cover every possible summing and counting formula. But it will provide you with some useful techniques that you can incorporate into your worksheets. If you have a need for a specific formula, or need help with adapting one of the formulas listed here, don't overlook the  HYPERLINK "http://communities.microsoft.com/Newsgroups/default.asp?ICP=prod_office&sLCID=US&NewsGroup=microsoft.public.excel.misc&iPageNumber=1" Excel newsgroups. John Walkenbach is an Excel MVP and has written more than two dozen Excel books, including the bestselling Excel 2002 Formulas. He also maintains  HYPERLINK "http://j-walk.com/ss/" The Spreadsheet Page, a popular Web site for Excel users of all levels. &'TUV      2 3 Y Z [ \ ] ^ _ `    ! jj h Uj h Uj& h U h <j?h Ujxh Uh B*CJOJQJaJphfffjh Ujh Ujh Uh 6CJ]aJh CJaJh :&'TUuo$If=kd`$$If!634ap $If\$=kd$$If!634ap $IfQ0  2 qii$IfK$Hkd$$If!  634ap d$If=kd1$$If!634ap  >8$IfVkdd$IfK$L$0n!!634ap $$Ifa$K$$IfK$Vkd$IfK$L$02634ap ] qlf$Ifgd Hkd$$If!  634ap d$If=kd$$If!634ap ] ^ _ ! " RJJ$IfK$bkd $IfK$L$0  6 -A 6-34ap$IfK$gd =kd $$If!634ap ! " #  [ \ ] ^ _ ` a b c d ˶˝˶|p|pdp|_Ojh CJOJQJUaJ h <j h OJQJUjh OJQJUh OJQJ1jTh 5;B*CJOJQJU\aJph1jh 5;B*CJOJQJU\aJph(h 5;B*CJOJQJ\aJph1jh 5;B*CJOJQJU\aJphjph Uh jh Uh CJaJ _ ` a b qi*>kd$IfK$L$I A 634ap $IfK$kd$IfK$L$F I A ; ؐA 6    34apؐ$IfK$b c @ A $IfK$Vkd$IfK$L$0I 634ap d$IfK$ $Ifgd d   > ? @ A B  efghijk()*+,.lºž¶º h 6]j#h Uj"h Uj h Uh OJQJjh Uj;h Uh jh Uh CJaJh 0JCJaJj#h CJOJQJUaJjh CJOJQJUaJh CJOJQJaJ2i_WW$IfK$@kd$IfK$L$xA A 634xap $IfK$Vkd$IfK$L$0I 634apij,-$IfK$xkdt!$IfK$L$F y  6 -A 6    -34ap-.m$94{c & F@dd$If[$\$^@gd $If$Ifxkd%$IfK$L$F y  6 -A 6    -34ap"$%Kij5)@Af+C~w3 !!!"%###v%%%÷÷÷÷h CJaJh OJQJ h 5\h 56\]h CJOJQJaJh 5CJOJQJ\aJ"h 56CJOJQJ\]aJ h 6]j%h Uh jh U64K5)Rf{c & F@dd$If[$\$^@gd $If & F@dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd $If & F@dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  C~wic$If & F Udd$If[$\$^Ugd  & F @dd$If[$\$^@gd  & F @dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd $If & FUdd$If[$\$^Ugd  3 !!!Z"i & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd  & F Udd$If[$\$^Ugd  & F @dd$If[$\$^@gd $If Z"""###v%%%%$IfK$ & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd $If$If %%%%%`XXX$IfK$kd16$IfK$L$KFh !06    34Kab p%%%%%%%%%%%&&&&&&,&-&:&;&H&I&U&V&]&^&&M'''(()*c**+`++%-x-..;/$IfK$L$KFh !06    34Kab pH&I&N&S&U&`XXX$IfK$kdc?$IfK$L$KFh !06    34Kab pU&V&^&M'w'`ZZB & F@dd$If[$\$^@gd $Ifkd9@$IfK$L$KFh !06    34Kab pw''(((*P*c*+I+i & F@dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd  & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd $If & FUdd$If[$\$^Ugd  I+`+%-a-x--O/O0P0Q0nl=kdA$$If!634ap $If & FUdd$If[$\$^Ugd  & F@dd$If[$\$^@gd $If & FUdd$If[$\$^Ugd  1h/ =!"#$%^$$If!vh5!#v!:V 6,534 p ^$$If!vh5!#v!:V 6,534 p qDdJ  S &AtsbNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`^$$If!vh5!#v!:V 6,534 p qDdJ  S &AtsbNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`t$$If!vh5!#v!:V   6,534 p qDdJ  S &AtsbNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`y$IfK$L$!vh55#v#v:V 6,534 py$IfK$L$!vh5n!5R#vn!#vR:V 6,534 p^$$If!vh5!#v!:V 6,534 p qDdJ  S &AtsbNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`t$$If!vh5!#v!:V   6,534 p qDd#J  S &AtsbNu6Œ݂4j nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`^$$If!vh5!#v!:V 6,534 p sDdL  S (Ats*bNu6Œ݂4; nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`sDdL  S (Ats*bNu6Œ݂4 nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`$IfK$L$!vh55I #v#vI :V 6 -A 6-,534 psDd#L  S (Ats*bNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`qDdJ   S &AtsbNu6Œ݂4'nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`Dd,b   c 8AVDC"à0 <!-- if (fBrowserOK) { document.write("<td style=\"width:1px;background-color:#999999;\"></td>") document.write("<td id=\"arrowColidRelated\" bgcolor=\"#F4F4F2\" width=\"21\" height=\"17\"><img id=\"ImgArrowidRelated\" src=" + sImgDefaultArrow + " alt=\"collapse menu\" border=\"0\" style=\"cursor:hand;\" onclick=\"change_display\(\'headingidRelated\'\)\"></td>") } //--> type="text/javascript"javascript b}Lacb!cn}Lacb!cPNG  IHDRfsRGB@}0PLTEO&IWIDATcPܿH\7L , QB@ !lؠ y`&0Mhpb3IENDB`DdI;   c A$arrow_defaultImgArrowidRelatedcollapse menu b=dhM13fdn=dhM13fPNG  IHDRHuPLTEdV:qtRNS0J cmPPJCmp0712OmIDATcV|?fj \ /$IENDB`$IfK$L$!vh55q5<#v#vq#v<:V  ؐA 6,5A 55;/ 34 pؐ[$IfK$L$!vh5I #vI :V A 6534 p Dd&&T   S 0AreLink2 b(h]Xoh~>/gn(h]Xoh~>/PNG  IHDR Ÿ PLTEf⌂JtRNS@*bKGDH cmPPJCmp0712OmIDATc:~ī#+8tm\IENDB`$IfK$L$!vh55~#v#v~:V 6,55/ 34 pqDd#J   S &Ats bNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`qDd#J  S &Ats bNu6Œ݂4nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`}$IfK$L$!vh55~#v#v~:V 6,534 pc$IfK$L$x!vh5A #vA :V xA 6534xp sDd#L  S (Ats*bNu6Œ݂4E nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`$IfK$L$!vh55I 5#v#vI #v:V 6 -A 6-,534 psDdL  S (Ats*bNu6Œ݂4^"nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`sDdL  S (Ats*bNu6Œ݂4#nNu6Œ݂4PNG  IHDR%VsBIT|.wPLTEٟtRNS@fbKGDH cmPPJCmp0712Om IDATc`clIENDB`$IfK$L$!vh55I 5#v#vI #v:V 6 -A 6-,534 pDdd  S \A img_excelgraphExcel worksheetbyyXgE%nyyXgEPNG  IHDRC$0PLTEʌaag***4w33fЀ2 bKGDH cmPPJCmp0712OmIDATxkGc;,K^1bhYQc Jx=8NX*Y CGk Ba@ZM=& z3ȶ&(~y0`ZrBZ/hds$:W֠[\zYe@/\'tu^v =4L^QF衖>Yf~m{tu9c1ϴ=}fP\wxE 2<\1#r1ŇƐit0wP1|maPyܯ=6UkSNH ^UL='z=O:; 3Y.TGo_/4N}qśI<~-ף0]I>$o=}}'..ы|ѷOF&L~=8L??s#WoN.>Ws?z&AU~ώ{z)_>:;m{߹Wwۻw_=GoϾzW'՟XʁG/W_Kޢ[?}osoҟyf32--=Y=߻u?~y -g{ëG{޿Gߖe4&qu~au6W?|4{D~y{ӓ7zzޏ_[7_VMѹYˇя;~z<ˣы{ѓޏ!׏_}qt?\_{h~џ?|^yt[촾W}*s_MGڹN=2w[wB3(G~ɦ0G:gtt.]KX7f1B %;3oovK <@WXaTNRy]"TرȊXFRtnkѳ|E׆L+Z*]kҹæ|cǧk35Nzh5j4TD5Y| OK6vWE}>7 HbZr$?d]LyϼFtnlLߥ*,ǒwߘ.TSd ]C _coYas7;{ q:T8sXkRGtoevm뻠CAl3O0ݦ.}[GoF =]g+Tt{~fS wFӓYeyܯ\Hfۧ1\υ$.օn'`AURS}ڽpNBxAؓZVtQA.+vOS /azsOSW)?*K7&ReNo:t𤏤i.&uHYLB Х3:+,S)b+i3OE 3> yC'҅/̱Z]K+ʠ')tV)JQi{CMvcm˪K> Z.C=ON у}Ƭn_ߣف=+Pl+O`2};mjz}w5_G? }Ȣ$} hoyu.6 Oϕkv@S+l w=߄ݲؓ *aVts1HH  fn7H;{I:Ae;-;Or吆>1^qyX>9%:a>>t ]-C+ղڢTn<}k]U ]eŠW)Ņfc˪T}4BcUu;UVݔ4j{Joς:ݶ`,jEePH۬ e,}GXed&,ǎn 7QϏC/1aAA-IO:NnQtQ75?VLX)>Ďuґ%8scG:.ca]3 yt\%H+Z ]v J/Ksާ$ tގL!^[]u]o,ܙq>)? ;FqOe˷0}Ϲϭާ},^2{TyLzrkV8s,TK|'34c촁wwHO,KC MwtK՘QؓE.) L1]r=*z$Bgwkxeaݻ_Ʀs jЍ2;5_%&rVQ*!?bȺPo R?WUUsT U54BUE7Z|KGh^Q쀶yk,HK_{q*1:&íR0,spPS5{]] .z7s Lz }MU#:G 宰9W{WqC_0\l뼯Z%Б0K`ѹ(3+RE( *S<躢Y F:Y ot؞ ]HR6ysX誂>VUhUIg/I&Cg|tb D{_w,Y<e6`HiJ&}@渾DEݤ3<"]߱=Ffȋܖn"9wz3R ^V:win7?jOz?WNoYY@0& ?Ꮷ,Ѭw:_#;vN}42t4}k}_.5n}^ÇH5f&P6mj +JQX-@G [WUg#n9zTcfZtd$~~2kHU^MT1i/|иIVGot;TuTG-+b:`:1 Քbz]S3Š/u>w`w]rrhPYt@__quۆSLNw@|ԬHMl^.{m 'w@>wnhkJI)Dz̀ؓ/KA03a4F~inع;Sd|41 Wa70pTZLav,>ThV}_>6<'T_No]~٧t~?+\"BBkIENDB`$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34Kp$IfK$L$S!vh5` 55 5#v` #v5 #v:V K065/ 34KpX$$If!vh5!#v!:V 6534 p @@@ NormalCJ_HaJmH sH tH Z`Z  Heading 1dd@&[$\$5CJ0KH$OJQJ\aJ0V`"V  Heading 2dd@&[$\$5CJ$OJQJ\aJ$N`2N  Heading 3 d@&[$5CJOJQJ\aJDA@D Default Paragraph FontRi@R  Table Normal4 l4a (k(No List>U`>  Hyperlink>*OJQJo(phfB^`B  Normal (Web)dd[$\$Q(x&'TU2]^_!"_`abc@Aij,-.m $ 9  4 K 5 )RfC~w3Zv %*,-38:;AFHINSUV^Mw "P"c"#I#`#%%a%x%%O'O(P(S(0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 00 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000 0 0 00 0 0 00000 0 000 0 00 00 0 0000 0 000 0 00 0 00000 0 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 00 0 00 0 00 0 00 0 0000 0 0&'TU2]^_!"_`abc@Aij,-.m $ 9  4 K 5 )RfC~w3Zv %*,-38:;AFHINSUV^Mw "P"c"#I#`#%%a%x%%O'O(P(S(^~0mJ  ^~0mK    ^~0m:K< @ D H  ^~0mrKt x |  ^~0m^~0mK  ^~0 m^~0 mzM|  ^~0 mrOtx| ^~0mO <^~0m^~0mBKD H L P <^~0m^~0m^~0m^~0O ^~0m^~0m^~0m^~0mO^~0mBPDHLP^~0m^~0m^~0mI  ^~0m^~0mI    ^~0mfJh l p t  ^~0m^~0mP>m  ^~0 m^~0 m^~0 mP(@mx |  ^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" m^~0" mP0Bmptx ^~0$m^~0$m^~0$mJ    ^~0&m^~0&m^~0&m6K8 < @ D  ^~0(m^~0(m^~0(mnKp t x |  ^~0*m^~0*m^~0*mK  ^~0,m^~0,m^~0,m L    ^~0.m^~0.m^~0.m6L8 < @ D  ^~00m^~00m^~00mnLp t x |  ^~02m^~02m^~02mL  ^~04m^~04m^~04mL    ^~06m^~06m^~06m6M8 < @ D  ^~08m^~08m^~08mM  ^~0:m^~0:m^~0:mM  ^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m^~0< m\~0< \~0< \~0<   N$(,0  ln! d %Q0 #'- ] b i-4Z"%%%%%%&&&,&:&H&U&w'I+Q0!"$%&()*+,./0123456789:;Q0U2Y[_"[]c>Aegj(* &;'L''((Q(CCCCCCCCCCCXCCCCCCXX8@0(  B S  ? U,UtU$UhUU4UTUUXUU4!dd!!%L%L%S(  1jj%% #%R%R%S( 8 *urn:schemas-microsoft-com:office:smarttagsCity9 *urn:schemas-microsoft-com:office:smarttagsplace?*urn:schemas-microsoft-com:office:smarttags stockticker8 *urn:schemas-microsoft-com:office:smarttagsdate 10162002DaylsMonthtransYear   6@T'^'S(T V q s {b f S(333333S(c,HEf vXzZ,"r{-i2T}%U2j[}8D2c><`C"tb'N(jZV*VÌWo92ybdoc>do}%U2Peo}%U2eoem~foem~for{-gor{- ho92yhoXTioXio`Cjo`CjoV*VkoV*V$loc,loc,Xmo"$no"noWoXooWooo'Npo'Npof qof (rob?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F0oSRData =iA1Table^[sWordDocument"xSummaryInformation(DocumentSummaryInformation8CompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q