аЯрЁБс>ўџ 79ўџџџ6џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС'` јПAbjbj$š$š . F№F№A џџџџџџЄдддддддш    Є ш vФ к к к к к к к ˆŠŠŠŠŠŠ$hч‚Ўдк к к к к Ўддк к Ур р р к :дк дк ˆр к ˆр р дд0к И @ЏУWkЫ  j ˆй0 (i~ Xi0iд0Xк к р к к к к к ЎЎж к к к к к к к шшшфЬФшшшЬшшшддддддџџџџ How to Use Excel's DSUM Function By an eHow Contributor  HYPERLINK "http://www.ehow.com/account/simple_login.aspx" I want to do this! What's This? Excel's DSUM function is short for "database sum." It adds the values in a column of a database that match the specified criteria. DSUM then calculates its return value in the same manner as SUM, which simply takes its values directly from the argument list. The following steps will show how to use Excel's DSUM function. Difficulty: Moderate Instructions Learn the syntax of DSUM (database, field, criteria). Database is a cell range that specifies the database, field is a column in the database from which DSUM will add values and criteria is a cell range with the criteria to be used in selecting the values. Define the database for DSUM. The first cell in the range will indicate the upper left corner of the database array and the second cell will indicate the lower right corner of the array. The first row of the array must contain the column names. Specify the field for DSUM. It can include the column name enclosed in double quotation marks or a number representing the column's position in the database where 1 is the first column, 2 is the second column and so on. Supply the criteria for DSUM. This cell range must contain at least one column name and one condition for that column. The condition will generally be of the form ="condition." Thus, a value of ="=Apple" would select rows where the value in the specified column is equal to "Apple." Enter the following in the first four columns of an Excel spreadsheet: Row 1: Tree, Height, Age and Yield; Row 2: ="=Apple" and =">10" (nothing in columns three and four); Row 3: ="=Pear" (nothing in columns two, three and four); Row 4: Tree, Height, Age and Yield; Row 5: Apple, 18, 20 and 14; Row 6: Pear, 12, 12 and 10; Row 7: Cherry, 13, 14 and 9; Row 8: Apple, 14, 15 and 10; Row 9: Pear, 9, 8 and 8; and Row 10: Apple, 8, 9 and 6. Interpret the formula =DSUM(A4:D10,"Yield",A1:B2) as follows: The database is defined as the array A4:D10. Note the column names in the first row of this array. "Yield" is the column name from which the values will be taken. The criteria are given by A1:B2 which indicates that the column named Tree must contain "Apple" and the column named Height must contain a value greater than 10. DSUM(A4:D10,"Yield",A1:B2) will therefore be evaluated as SUM(14,10)=24. If Function One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If the value does meet the condition, one result will happen, if false, a different action will occur. Writing the IF function: =IF(logical_test, value_if_true, value_if_false) IF Function example: =IF(D1 < 26, 100, 200) Breaking the example down into its three parts we have: logical test: D1 < 26, ("<" means less than) value if true: 100 value if false: 200 The results of this function will be: 1) If the value in D1 is less than 26, the value shown will be 100. 2) If the value in D1 is NOT less than 26, the value shown will be 200. !89:uvˆ‰˜л м uwƒšЃинь№ˆэнЯЛЋЛ™ЛЋ‡pЯlgWDWDWDW%hмhш\ЦB*CJOJQJaJph333hш\ЦB*CJOJQJaJph333 hш\Ц5hш\Ц,jhш\ЦB*CJOJQJU^JaJph#hш\ЦB*CJOJQJ^JaJph"hш\Ц0J<B*OJQJ^Jphtшhш\Ц<B*OJQJ^Jph'jhш\Ц<B*OJQJU^Jphhш\ЦB*OJQJ^Jphhш\Ц0JB*OJQJ^Jph#hш\ЦB*CJ$OJQJ^JaJ$ph!9˜л ё ў џ  і ї г д я № ЈЉuƒˆњѕѕщѕфбШбШбШбШбШбШУѕgdш\Ц„w^„wgdш\Ц & F„wЄdЄd[$\$^„wgdш\Цgdш\Ц d8Є–Є–gdш\Цgdш\Цgdш\ЦA§ˆ Ђгчщџ9GNux‰Œ?@AьмЩьмЩЙмЙЩЙЩЙЩЙмьмБ­hp9ВhёZіhш\Ц5hш\ЦB*CJOJQJaJph333%hш\Ц5B*CJOJQJ\aJph333hш\ЦB*CJOJQJaJph333%hш\Ц5B*CJOJQJ\aJph333ˆЂгщ9Гї?@AюююсюсюЩЩФТgdш\Ц„„џЄdЄd-DMЦ џџџџ[$\$^„„џgdш\Ц -DMЦ џџџџgdш\ЦЄhЄh-DMЦ џџџџgdш\Ц ,1hАа/ Ар=!А"А# $ %ААаАа а;Dd,сшш№ЦВ № c №:AСџПNormalFax01C"ё`ŽУ—У0˜П€€ jQuery('.intro .thumbnail').each(function(i,e){ jQuery(e).find('img').one('error',function(){ jQuery(e).remove(); }); }); type="text/javascript"№€b№!Xтѓ†Ё‘ЖœЅПNЄB џ§DYn№ѕXтѓ†Ё‘ЖœЅПNЄB џ‰PNG  IHDRЖђfsRGB@Р}Х0PLTE€€€€€€€€€€€€РРРџџџџџџџџџџџџ{БФbIDATгEŽ!Р0Eqˆ‰^uЎM&V‰ыUp“\ З&ˆЎЄC|ёђѓјзС)"3.8ЬДŒЭьў(6 jPtsЪ„˜œ&Њй)ЗNбU- \^w‘& У^eyћњЦОс_іc|_ˆќт^9IENDЎB`‚†œ@`ёџ@ ш\ЦNormalCJ_HaJmH sH tH L`L ш\Ц Heading 1ЄdЄd@&[$\$ CJ0KH$aJ0H`"H ш\Ц Heading 2ЄdЄd@&[$\$CJ$aJ$DA@ђџЁD Default Paragraph FontRiѓџГR  Table Normalі4ж l4жaі (kєџС(No ListB^`ђB ш\Ц Normal (Web)ЄdЄd[$\$0a`Ђ0 ш\Ц HTML Cite6€]€$ўoЂ$ ш\Цtext19A  џџџџ!9˜лёўџіїгдя№ЈЉu ƒ ˆ Ђ г щ 9  Г ї ? @ C 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€€!9˜лёўџіїгдя№ЈЉu ˆ Ђ г щ 9  Г ї ? @ C š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€ё€š@0€€ъа00оš@0€€ъа00цъа00 ъа00цъа00цъа00цъа00€ъа00 @00x 00F ˆA ˆA A 9uˆA XџŒ'+І В Д С У б C ajЈЉРХ, 1 — Ÿ Ѓ І ъ э 9 @ C 3333333ўўііггяяЈЈ@ C C ZлЂўrџџџџџџџџџ„а„˜ўЦа^„а`„˜ў.€„ „˜ўЦ ^„ `„˜ў.€„p„˜ўЦp^„p`„˜ў.€„@ „˜ўЦ@ ^„@ `„˜ў.€„„˜ўЦ^„`„˜ў.€„р„˜ўЦр^„р`„˜ў.€„А„˜ўЦА^„А`„˜ў.€„€„˜ўЦ€^„€`„˜ў.€„P„˜ўЦP^„P`„˜ў.ZлџџџџџџџџахЯп3%2)Хh R |e |x u О_PukЄТKDкSяu>Œ+dп ђSч1 ip э3#ф+%—P'6)F;*r,б).9,0бe002ёP2TY2Шa2а}4ˆ:0T:;V;Ы <Ё>!>q>$@ШA tA5CDC9Dt[EЦwE^F№PGб/JљaNХ OPV QqRJ SiTт;WexXйY'UY5SZ˜H[щ ^f^`+^yl__`†jbЋ3cVmcZ:dšqe…~e:f9vfЈgHgБh Vhy7iЙjmLon