Microsoft Excel ??? ????? ??? ??????? ?? ????? ???? ????

???? ?????? ???? ??????
???? ID: 214249 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? ???? Microsoft Excel ??? ????? ??? ??????? ?? ????? ???? ?? ??? ???? ?????? ???

????? ??? ??????? sums ??? ????????? ?????? ???? ???? ???? ?? ???? ???? ??? ??? ???? ??? 97 ?? ??? ??? Microsoft Excel ??????? ?? ??? ????? ???

??-?? ?? ?? ???? ??? discussed ?? ??? ??? ???? ??? ?? - ??? Microsoft ?????? ???? ?? ?? ????? ???? ?? ???? ??? ???????????? ???? ?????? ?? ??-?? ?? ?????? ??????????? ?? ??????? ?? ??? Microsoft ?????? ??????????? ??? ??? ?? ???? ???, ?????? ??????? ???? ?????? ??-?? ?? ?? ??????????? ?????? ???? ?? ????

???? ???????

????? ??? ??????? aids ????? ??? ?? ????????? ?????? ???? ???? ???? ????? ?? ?? ??? ????? ??? ????? ??? ??? ?? ??-???? ?? Excel ?? ??? ????? ???, ????? ?? ???????? ??? ?? ??? ???? ??? ?? ?? ???

???????? ?? ???? ????? ?? ?? ?????? ??????? ???? ?? ??? ???? ?? ????? ?? ???? ???, ???????? ??? ???????? ??? ?? ??????? ????? ????? ???

??? 1: ????? ???? ??????

?? ??? ???, ?? ???? ?? ????? ??? ?? ??? ????? ??? ???? ???? ?????? ?? ?????? ????????? ??? ?? ?????? ????? ????? ?? summed ?? ???? ?? ??? ???? ??? ?? ???? ?? ??? ??? ????? ???? ?? ??? ?????? defining ???? ???? ????? ???? ?????? ??? ?? ??? ???? ???, ???? ???? ?????????? ?? ??? ??????? ???? ?? ??? ?????

??????? Excel ???? ?????, ???? ??????? ??????? ???? ?? ???? ???????? ??? ?? ??? ????? ???? ???? ?? ???? ?? ??????? ??????? ???? ??? ????? ???? ???? ?? ???? ??, ??? ?? ?????? ????? ??? ???? ?????? ????? ???? ???? ?? ???? ?? ??? ??? ?????? ?? ??? ???

???:: ??? ?? ??? ??? ????????? ???? ?????? ??? ????? ????? ?? ??? ?????????? ??? ????? ????? ??? ????? ????? ?? ???? ??????? ?? ????? ???? ???? ???

??? 2: Summed ???? ?? ??? ???? ?? ????? ???? ?? ??? ?????? ?????

????, ???? ????? ?????? ?? ??? ???? ?? ??? ??? ????????? ?????? ???? ???; ??? ????? ??? 1 ??? ???? ?????? ????????? ???? ?????? ??? ????? ????? ??? ?? ???? ??? ???? ?? ??? ?????

???????, ?? ??? ?? ??? ?????? ????????? ?? ???????? ??? ???????? ?????? ???? ???????? (?? ????? ?????), ?? ??????, ?? ??? ??? ??? ???????? ?? ????????, ?? ??? ??? ???? ?????? ???? ???? ??? ?? ??? ?? ???? ??? ?? ?? ??? ?? ????????? ?? ??? ?????? ???? ??? ???? ?? ?? ???????? ???? ?? ?? ?? ??? ???? ?? ???? ????

?? ??? ?? ????????? ?? ??????? ?? ???? ???? ?? ???????? ?????? ??? ???? ??, ?? ??? ????? ???????? ?? ??????????? ?? ??? ?????? ?? ???? ?? ???? ??? ?? ??? ????? ?? ??? ???? ??? ???? ?? ????????? ???? ?? ??? ????? ???????? ?? ????????? revise ???? ?? ????

??? 3: ????? ?????? ?? ??????

?? ?? ?????? ?? ?? ?????? ??? ????? ??? ??????? ?? ???? ???:
  • ???? ??? ???? ?? ??? ???? ????? ?? ????????? ?????? ???????? ??? ?? ?? ????? ???

    -??-
  • ????? ?? ????? ????? ?? ????????? ??????

    ?? ????????? ????? ??? ?? ?? ???? ???????? ??? ?????????? ?? ???? ??? ?? ?? ?????? ?? ????? ???, ?? ????? ?? ??????? ?? ???????? ??? ?? ???? ???? ???? ???? ???? ?????????? ?? ??? ??? ???? ????

??? 4: ?????? ???? ????? ????

?? ??? ??? ?????? ??????? ?? ??? ?? ?????? ?? ??? 3 ??? ????? ??? ?????? ???? ??? ????? ????? ??? ?? ??? ?? ????? ????:
  • ??? ???? ???? ?????? ???? ?? (??????, ???? ????????? ???? ???? ??? ?? ??????? ???????? ?? ??????), ??? ?? ??? ?? ?? ?????????? ?? ????? ??? ?? ?????? ?? ??? ???? ?? ??? ???? ?? ???????? ??? ?? ???? ?? ??? ???? ?? ??? ?? ???? ???, ?? ???? ?????? ??????

    -??-
  • ??? ???? ??? 3 (??????, ????? ??????? ?????????? ??? ?? ?????????? ??? ??????) ??? ????? ?????? ???? ??, ?? ??? ???? ???????? ?? ?????? ?? ??? ?? ??? ??? ?? ??? ???? ?????? ?????? ????? ?? ??? ?????? ??? ?? ???? ?? ??? ???? ?? ??? ?? ???? ???, ?? ???? ?????? ?????? ???? ???? ?????? ??? 2 ??? ????????? ???????? ?????? ?? ??? ?? ???????? ??? ??? ??????
???:: ????? ??? ??????? ?? ????? ?? ???? ?? ??? ??????? IF ?????? Microsoft Excel ??? ?????? ???? ??? ???????? ?? ????? ???? ?????? ?? ????????, ?? ??? ?????? ?? ???? ?? ??????

????? ??? ??????? ??? ???? ?? ??? ???? ????

????? ??? ??????? ???????? ??? ?? ??? ???? ??? ???? ??? ??? ???? ???, ?? ?? ????????? ???? ?? ????????????, ?? ??? ???????????????? ????? ??? ?? ???? ?? ???????, ?? ??? ?? ???, ???? ?? ????? ????????? ????? ????? ???? ??, ?? ???? ??-?? ??? ???? ?? ????

????? ??? ??????? ?? ??? ???? ?? ??? ????? ????? ?? ???? ????:
  1. ????? ????????????? ??,??-????
  2. ???????-?? ?????????? ???, ?? ??? ????????? ??? ????????? ????-????? ????, ?? ???? ???OK.
?????? ?????? ?? ??? ????? ??????? ???? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
119591?????? ?????? ?? Microsoft ?????? ??????? ???? ??????? ????

????? ??? ??????? ?? ????? ???? ??? ??????

  1. In a new Microsoft Excel worksheet, insert the following, with the label???????in cell A1:
        Region   Date        Total Sales    Sales Rep
        South    1-Jan-96    $103,476.98    John Smith
        East     1-Jan-96    $57,400.35     John Smith
        North    5-Jan-96    $95,375.34     Mary Jones
        East     9-Jan-96    $143,564.6     John Smith
        West     9-Jan-96    $200,359.85    Mary Jones
        North    9-Jan-96    $204,014.46    Mary Jones
        South    9-Jan-96    $98,435.12     Mary Jones
        West    13-Jan-96    $65,678.41     John Smith
        West    14-Jan-96    $138,357.60    John Smith
        East    23-Jan-96    $69,189.58     John Smith
        North   23-Jan-96    $40,781.30     Mary Jones
        East    25-Jan-96    $89,053.68     Mary Jones
        North   31-Jan-96    $85,462.12     John Smith
        South   31-Jan-96    $199,980.15    Mary Jones
    					
  2. Ensure that the selected cell is within the list, on the????????? ??,Wizard?? ????-????? ????, ?? ???? ???Conditional Sum.
  3. ?????Step 1 of 4dialog box, the range
    $A$1:$D$15
    should be identified. If it is not, type the correct range, and then clicknext.
  4. ?????Step 2 of 4dialog box, in theColumn to sumbox, selectTotal Sales.
  5. ??????????box, selectSales Rep; in theIsbox, select=; in theThis valuebox, selectMary Jones; and then clickAdd Condition.
  6. ??????????box, select??????; in theIsbox, select>; in theThis value????? ???,10-Jan-96; and then clickAdd Condition.
  7. ????? ????,next.
  8. ?????Step 3 of 4????? ????? ???, ?? ??? ????Copy just the formula to a single cell. Notice that the result shows $329,815.13, and then clicknext.
  9. ?????Step 4 of 4dialog box, type the cell addressF1?? ????-????? ????, ?? ???? ?????????.

Known issues that may occur when you use the Conditional Sum Wizard

If the file name or the sheet name is too long, the Conditional Sum Wizard will fail with a "Runtime error 1004: FormulaArray method of Range class failed" error when the following conditions are true:
  • You try to copy both the criteria and the formula to another sheet in the workbook.
  • You apply several conditions.
When Excel builds the string for the formula array, Excel includes the workbook name with every criteria reference. The string may exceed the 255 character limit for FormulaArray method. Even though the workbook names are removed when the formula is entered, the method does not succeed because the character limit was exceeded.

??????

For more information about add-ins, clickMicrosoft Excel ???????? ???????????, ??????add-in programs for Microsoft ExcelOffice ????? ?? ????? ????????, ?? ???? ???????????? ?? ????? ?? ??? ???? ????

???

???? ID: 214249 - ????? ???????: 20 ??????? 2011 - ??????: 3.0
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 98 for Macintosh
??????: 
kbhowto kbmt KB214249 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:214249

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com