????? ??????? "????? ??????? ??????" ?? Microsoft Excel

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

?? ??? ??????

??????

???? ??? ?????? ????? ??????? "????? ??????? ??????" ?? Microsoft Excel.

?????? "????? ??????? ??????" ?? ???? ???????? ????? ???? ??? ??????? ???????. ??? ??????? ?? ??????? Microsoft Excel 97 ?????????? ??????.

??????? ???????? ???? ??? ???????? ?? ??? ??????? ??? ????? ??- ??. ??? ???? Microsoft ?? ???? ???????? ?? ???? ???????. ??? ????? ?? ?? ????? ??????? ????? ??? Microsoft ?? ??????? ???????? ???????? ??? ??????? ???????? "? ?? ?????? ?????? ??????? ???????? ??? ????? ????? ?????.

??????? ????

????????? "????? ????? ??????" ?? ????? ????? ???? ???? ????? ?????? ?? ????? ???? ??? ??????? ???????. ??? ????? ?? ??? ????? ?????? ???? ?? ??????? ?? Excel ???? ???? ?? ??? ????? ???? ???????.

?????? ??? ???? ?? ???? ?? ??????? ??????? ??? ?? ????? ????? ??????? ???? ?? ?????????.

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

?? ??? ??????? ??? ???? ??????? ???? ????? ??? ???????? ?????? ???????? ??????? ?????? ". ??? ?? ????? ??? ?????? ?????? ??????? ???????? ???? ????? ??? ?????? ???? ??? sum_range ???????? ??? ?????? ????? ?????? ???????? ?? ???????. ??? ???? ??? ?????? ???? ??? ????? ????? ??????? ?? ???? ?????.

??? ???? ????? ?????? Excel ??????? ????? ????? ?????? ???????? ??? ???? ?????? ??????? ??? ??????? ??? ??? ????? ???????. ??? ???? ??????? ??????? ???? ??????? ??? ????? ?????? ????? ?????? ?????? ???????? ?????? ?? ?????? ????? ??? ?????? ???????.

??????: ??? ?????? ???? ?????? ??????? ?? ???? ???????? ?????? ?? ??? ??????. ??? ??????? ?????? ??????? ?? ??????? ??????? ?? ???????.

???? 2: ????? ???????? ??????? ???? ??? sum_range ??????? ?????

?????? ????? ??? ????? ???? ????? ????? ??? ????? ???? ???? ?????? ???????; ?????? ????? ????? ????? ??? ?????? ??????? ?? ???? ???????? ???? ????? ?? ?????? 1.

??????? ??? ????? ???? ???????. ????? ?? ??? ????? ??? (????? ????) ???? ????? ?????. ??? ????? ????? ??????? ?????? ?????? ????? ??? ????? ???? ????? ?? ??????? ???????? ?? ????? ????? ???? ??? ?????.

????? ????? ???? ??? ????. ??? ????? ?? ??? ???? ??? ????? ??? ??????? ??? ????? ??????. ??? ??? ???? ?? ?? ??? ??? ????? ??? ????? ??? ???? ??? ??? ????? ??? ?????? ???????.

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

????? ?????? ??? ???? ??????? ?? "????? ????? ??????":
  • ??? ?????? ??? ??? ???? ?????. ??? ????? ??? ?????????.

    - ?? -
  • ??? ?????? ???? ??????.

    ???? ??? ??? ??? ?????? ??? ??? ???????? ????? ??? ???? ?????. ??? ??? ??????? ??? ??????? ????? ????? ??? ???????? ??? ??? ?????? ??? ????? ?????? ?? ???????? ???? ??????? ??? ????.

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

????? ????????? ???????? ?? ??? ?????? ??? ?????? ???? ?????? ?? ?????? 3. ???? ???? ??????? ???????:
  • ??? ??? ??????? ?????? ????? (??? ????? ??? ??????? ?? ?????? ???????) ? ?? ??? ?????? ????? ??? ????? ????? ?????? ?????? ????? ??????? ?????? ?? ???? ?????. ????? ????? ?????? ???????? ?????? ?? ????? ????? ???? ??????.

    - ?? -
  • ??? ????? ?????? ?????? ?? ?????? 3 (??? ?????? ??????? ????? ???????? ??????? ?? ???? ?????) ? ????? ??? ????? ????? ?????? ???????? ???? ????? ????? ?? ???????. ????? ????? ?????? ???????? ?????? ?? ????? ????? ???? ??????. ???? ???? ?????? ????? ??? ??? ?????? ?? ?????? 2.
??????: ?? ???? ??????? "????? ????? ??????" ?? ???? ????? IF ????????? ?? Microsoft Excel. ????? ??????? ???? ????? ??? ??? ?????? ??? ???? ?? ???? ??????.

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

?? ??? ????? "????? ??????? ??????" ???? ???????. ?????? ?? ??? ??? ????? ? ?? ??????? ????? ? ???? ?? ???? ??????? ?????. ???? ??? ?????? ?? ??? ??? ??????? ??? ??? ?? ??? ?????? ????? ???? ???????, ???? ????? ??? ????? ??????? ????????.

????? "????? ????? ??????" ? ???? ??????? ???????:
  1. ?? ??????? ?????? ???? ??? ????? ??????
  2. ?? ??????? ??????? ???????? ???????? ? ??? ????? ????? ?????? ?? ???? ??? ?????.
?????? ??? ??????? ?????? ??? ????? ??? ?? Online Services ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
119591????? ?????? ??? ????? ??? Microsoft ?? ??????? ??? ????????

?????? ???????? "????? ????? ??????"

  1. ?? ???? ??? Microsoft Excel ????? ????? ??????? ?? ????? ??????? ?? ?????? 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. ???? ?? ?? ?????? ??????? ???? ??????? ?? ??????? ????? ? ??? ??? ????? ?? ???? ??? ????? ????.
  3. ?? ???? ?????? ?????? 1 ?? 4 ??????
    $ A $ 1: D $ $ 15
    ??? ?????. ??? ?? ??? ???? ?????? ?????? ?? ???? ??? ??????.
  4. ?? ???? ?????? ?????? 2 ?? 4 ?? ???? ??????? ??? ??????? ??? ?????? ????????.
  5. ?? ???? ?????? ??? ????? ???????? "? ?? ?????? ?? ??? =; ?? ??? ?????? ??????? ??? Mary Jones; ?? ???? ??? ????? ???.
  6. ?? ???? ?????? ??? ??????? ? ?? ?????? ?? ??? >; ?? ??? ?????? ? ???? 10-????? - 96; ??? ?? ???? ??? ????? ???.
  7. ???? ??? ??????.
  8. ?? ???? ?????? ?????? 3 ?? 4 ??? ??? ?????? ??? ???? ?????. ???? ?? ??????? ????? $ 329,815.13 ?? ???? ??? ??????.
  9. ?? ???? ?????? ?????? 4 ?? 4 ? ???? ????? ?????? F1 ??? ?? ???? ??? ?????.

???????? ???????? ???? ?? ???? ??? ??????? "????? ????? ??????"

??? ??? ??? ????? ?? ??? ?????? ???? ???? ? ????? "????? ????? ??????" ?? "??? ??? ??????? 1004: ??? ??????? FormulaArray ??? ??????" ??? ????? ?????? ???????:
  • ??? ?????? ??? ?? ?? "????????" ? "?????? ??? ???? ???? ?? ??????.
  • ????? ?????? ?? ??????.
??? ????? Excel ????? ?????? ?????? ? ????? Excel ??? ?????? ?? ?? ???? ????????. ?? ??????? ?????? ?? 255 ????? ??????? FormulaArray. ??? ????? ?? ?? ??? ????? ????? ?????? ??? ????? ?????? ??????? ??? ???? ????? ??? ?????? ??????.

?????

????? ?? ????????? ??? ??????? ???????? ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ????? ??????? ???????? ??????? Microsoft Excel ?? "????? Office" ?? ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

???????

???? ???????: 214249 - ????? ??? ??????: 05/????/1428 - ??????: 2.4
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbhowto KB214249 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????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