{"id":5453,"date":"2024-11-11T10:57:16","date_gmt":"2024-11-11T10:57:16","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=5453"},"modified":"2024-11-11T10:57:16","modified_gmt":"2024-11-11T10:57:16","slug":"a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets\/","title":{"rendered":"Visaptvero\u0161a rokasgr\u0101mata par mas\u012bva formulas izmanto\u0161anu Google izkl\u0101jlap\u0101s"},"content":{"rendered":"

ARRAYFORMULA jaudas izmanto\u0161ana Google izkl\u0101jlap\u0101s<\/h1>\n

Funkcija ARRAYFORMULA<\/strong> pakalpojum\u0101 Google izkl\u0101jlapas ir sp\u0113les main\u012bt\u0101js, kas \u013cauj lietot\u0101jiem bez piep\u016bles lietot vienu formulu visai kolonnai. \u0160\u012b jaud\u012bg\u0101 funkcija nov\u0113r\u0161 nepiecie\u0161am\u012bbu p\u0113c garlaic\u012bgas kop\u0113\u0161anas-iel\u012bm\u0113\u0161anas vai formulu vilk\u0161anas pa vair\u0101k\u0101m \u0161\u016bn\u0101m, padarot datu manipul\u0101cijas \u0101tr\u0101kas un efekt\u012bv\u0101kas. Neatkar\u012bgi no t\u0101, vai r\u0113\u0137in\u0101t kopsummas vai veicat sare\u017e\u0123\u012btas darb\u012bbas, ARRAYFORMULA var apvienot ar cit\u0101m funkcij\u0101m, tostarp IF<\/strong> , SUM<\/strong> un SUMIF<\/strong> , lai efekt\u012bvi automatiz\u0113tu apr\u0113\u0137inus.<\/p>\n

K\u0101 lietot ARRAYFORMULA<\/h2>\n

\u0160\u012bs funkcijas izmanto\u0161anas sintakse ir ARRAYFORMULA(array_formula)<\/code>, ko var lietot, ja nepiecie\u0161ams viens arguments. Tas var ietvert funkcijas, kas darbojas ar vair\u0101kiem t\u0101da pa\u0161a izm\u0113ra mas\u012bviem, izteiksm\u0113m vai nor\u0101d\u012btajiem \u0161\u016bnu diapazoniem. Funkciju ARRAYFORMULA var ieviest vai nu p\u0113c formulas s\u0101kotn\u0113j\u0101s ievad\u012b\u0161anas, vai k\u0101 da\u013cu no formulas izveides procesa.<\/p>\n

Piem\u0113rs: kop\u0113j\u0101 p\u0101rdo\u0161anas apjoma apr\u0113\u0137in\u0101\u0161ana<\/h3>\n

Apskat\u012bsim scen\u0101riju, kur\u0101 jums ir j\u0101apr\u0113\u0137ina kop\u0113jais p\u0101rdo\u0161anas apjoms, reizinot p\u0101rdoto daudzumu<\/em> ar vien\u012bbas cenu<\/em> .<\/p>\n

    \n
  1. Izmantojiet \u0161\u0101du formulu: =ARRAYFORMULA(B2:B6*C2:C6)<\/code>lai reizin\u0101tu diapazonus B2 l\u012bdz B6 un C2 l\u012bdz C6.<\/li>\n
  2. Tikl\u012bdz nospie\u017eat Enter, kolonna Kopsummas tiks autom\u0101tiski aizpild\u012bta ar atbilsto\u0161o v\u0113rt\u012bbu reizin\u0101jumu.<\/li>\n<\/ol>\n
    \"Kop\u0113j\u0101s<\/figure>\n

    ARRAYFORMULA integr\u0113\u0161ana ar funkciju IF<\/h2>\n

    ARRAYFORMULA var neman\u0101mi str\u0101d\u0101t ar funkciju IF<\/strong> , \u013caujot iestat\u012bt nosac\u012bjumus da\u017e\u0101dos diapazonos.<\/p>\n

    Piem\u0113rs: Bonusa atbilst\u012bbas noteik\u0161ana<\/h3>\n

    Piem\u0113ram, ja v\u0113laties par\u0101d\u012bt \u201cBonuss\u201d par summ\u0101m, kas p\u0101rsniedz 20\u00a0000, un \u201cBez bonusa\u201d pret\u0113j\u0101 gad\u012bjum\u0101, varat \u012bstenot \u0161\u0101das darb\u012bbas:<\/p>\n

      \n
    1. Ievadiet \u0161o formulu: =ARRAYFORMULA(IF(B2:B6>20000, \"Bonus\", \"No Bonus\"))<\/code>lai nov\u0113rt\u0113tu visu nor\u0101d\u012bto diapazonu.<\/li>\n
    2. Nospie\u017eot tausti\u0146u Enter, rezult\u0101ti tiks attiec\u012bgi atspogu\u013coti bonusu sada\u013c\u0101.<\/li>\n<\/ol>\n
      \"Bonusa<\/figure>\n

      Izmantojot ARRAYFORMULA ar SUMIF<\/h2>\n

      ARRAYFORMULA var efekt\u012bvi apvienot ar SUMIF<\/strong> funkciju uzlabotai datu anal\u012bzei.<\/p>\n

      Piem\u0113rs: pas\u016bt\u012bto kancelejas pre\u010du skait\u012b\u0161ana<\/h3>\n

      Ja v\u0113laties apr\u0113\u0137in\u0101t pas\u016bt\u012bto kancelejas pre\u010du skaitu, veiciet t\u0101l\u0101k nor\u0101d\u012bt\u0101s darb\u012bbas.<\/p>\n

        \n
      1. S\u0101ciet ar formulu SUMIF(F2:F, H2:H, D2:D)<\/code>:.<\/li>\n
      2. Nospiediet Enter, lai skat\u012btu kop\u0113jo summu, piem\u0113ram, 32 \u0161\u016bn\u0101 I2.<\/li>\n
      3. Lai to papla\u0161in\u0101tu vis\u0101s kategorij\u0101s, izmantojiet: =ARRAYFORMULA(SUMIF(F2:F, H2:H, D2:D))<\/code>.<\/li>\n<\/ol>\n
        \"SUMIF<\/figure>\n

        Svar\u012bgi apsv\u0113rumi<\/h2>\n