{"id":5455,"date":"2024-11-11T10:55:52","date_gmt":"2024-11-11T10:55:52","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=5455"},"modified":"2024-11-11T10:55:52","modified_gmt":"2024-11-11T10:55:52","slug":"a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/a-comprehensive-guide-on-utilizing-the-array-formula-in-google-sheets\/","title":{"rendered":"Komplexn\u00ed pr\u016fvodce pou\u017e\u00edv\u00e1n\u00edm vzorce pole v Tabulk\u00e1ch Google"},"content":{"rendered":"<h1>Odemknut\u00ed s\u00edly ARRAYFORMULA v Tabulk\u00e1ch Google<\/h1>\n<p>Funkce <strong>ARRAYFORMULA<\/strong> v Tabulk\u00e1ch Google m\u011bn\u00ed hru a umo\u017e\u0148uje u\u017eivatel\u016fm bez n\u00e1mahy pou\u017e\u00edt jeden vzorec na cel\u00fd sloupec. Tato v\u00fdkonn\u00e1 funkce eliminuje pot\u0159ebu zdlouhav\u00e9ho kop\u00edrov\u00e1n\u00ed, vkl\u00e1d\u00e1n\u00ed nebo p\u0159etahov\u00e1n\u00ed vzorc\u016f p\u0159es v\u00edce bun\u011bk, tak\u017ee manipulace s daty je rychlej\u0161\u00ed a efektivn\u011bj\u0161\u00ed. A\u0165 u\u017e po\u010d\u00edt\u00e1te sou\u010dty nebo prov\u00e1d\u00edte slo\u017eit\u00e9 operace, ARRAYFORMULA lze kombinovat s dal\u0161\u00edmi funkcemi, v\u010detn\u011b <strong>IF<\/strong> , <strong>SUM<\/strong> a <strong>SUMIF<\/strong> , pro efektivn\u00ed automatizaci va\u0161ich v\u00fdpo\u010dt\u016f.<\/p>\n<h2 id=\"using-the-array-formula\">Jak pou\u017e\u00edvat ARRAYFORMULA<\/h2>\n<p>Syntaxe pro pou\u017eit\u00ed t\u00e9to funkce je <code>ARRAYFORMULA(array_formula)<\/code>, kterou lze pou\u017e\u00edt, kdy\u017e je vy\u017eadov\u00e1n jeden argument. To m\u016f\u017ee zahrnovat funkce, kter\u00e9 pracuj\u00ed s n\u011bkolika poli stejn\u00e9 velikosti, v\u00fdrazy nebo ur\u010den\u00fdmi rozsahy bun\u011bk. Funkci ARRAYFORMULA lze zav\u00e9st bu\u010f po prvotn\u00edm zad\u00e1n\u00ed vzorce nebo jako sou\u010d\u00e1st procesu vytv\u00e1\u0159en\u00ed vzorce.<\/p>\n<h3>P\u0159\u00edklad: V\u00fdpo\u010det celkov\u00fdch prodej\u016f<\/h3>\n<p>Uva\u017eujme sc\u00e9n\u00e1\u0159, kdy pot\u0159ebujete vypo\u010d\u00edtat celkov\u00fd prodej vyn\u00e1soben\u00edm <em>prodan\u00e9ho mno\u017estv\u00ed<\/em> jednotkovou <em>cenou<\/em> .<\/p>\n<ol>\n<li>Pou\u017eijte n\u00e1sleduj\u00edc\u00ed vzorec: <code>=ARRAYFORMULA(B2:B6*C2:C6)<\/code>pro vyn\u00e1soben\u00ed rozsah\u016f B2 a\u017e B6 a C2 a\u017e C6.<\/li>\n<li>Jakmile stisknete Enter, sloupec Totals se automaticky vypln\u00ed sou\u010dinem odpov\u00eddaj\u00edc\u00edch hodnot.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdpo\u010det celkov\u00e9ho prodeje\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-190-1.webp\" title=\"V\u00fdpo\u010det celkov\u00e9ho prodeje\" width=\"831\"\/><\/figure>\n<h2 id=\"using-the-if-function\">Integrace ARRAYFORMULA s funkc\u00ed IF<\/h2>\n<p>ARRAYFORMULA dok\u00e1\u017ee bezprobl\u00e9mov\u011b spolupracovat s funkc\u00ed <strong>IF<\/strong> , kter\u00e1 v\u00e1m umo\u017en\u00ed nastavit podm\u00ednky nap\u0159\u00ed\u010d rozsahy.<\/p>\n<h3>P\u0159\u00edklad: Ur\u010den\u00ed n\u00e1roku na bonus<\/h3>\n<p>Pokud nap\u0159\u00edklad chcete zobrazit \u201eBonus\u201c pro \u010d\u00e1stky p\u0159esahuj\u00edc\u00ed 20 000 a \u201eBez bonusu\u201c jinak, m\u016f\u017eete implementovat n\u00e1sleduj\u00edc\u00ed:<\/p>\n<ol>\n<li>Zadejte tento vzorec: <code>=ARRAYFORMULA(IF(B2:B6&gt;20000, \"Bonus\", \"No Bonus\"))<\/code>pro vyhodnocen\u00ed cel\u00e9ho zadan\u00e9ho rozsahu.<\/li>\n<li>Po stisknut\u00ed kl\u00e1vesy Enter se v\u00fdsledky odpov\u00eddaj\u00edc\u00edm zp\u016fsobem projev\u00ed v bonusov\u00e9 sekci.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159\u00edklad v\u00fdpo\u010dtu bonusu\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-193-1.webp\" title=\"P\u0159\u00edklad v\u00fdpo\u010dtu bonusu\" width=\"863\"\/><\/figure>\n<h2 id=\"using-the-sumif-function\">Pou\u017eit\u00ed ARRAYFORMULA s SUMIF<\/h2>\n<p>ARRAYFORMULA lze efektivn\u011b kombinovat s funkc\u00ed <strong>SUMIF<\/strong> pro pokro\u010dilej\u0161\u00ed anal\u00fdzu dat.<\/p>\n<h3>P\u0159\u00edklad: Po\u010d\u00edt\u00e1n\u00ed objednan\u00fdch pap\u00edrensk\u00fdch polo\u017eek<\/h3>\n<p>Chcete-li vypo\u010d\u00edtat po\u010det objednan\u00fdch kategorizovan\u00fdch pap\u00edrensk\u00fdch polo\u017eek, postupujte takto:<\/p>\n<ol>\n<li>Za\u010dn\u011bte vzorcem: <code>SUMIF(F2:F, H2:H, D2:D)<\/code>.<\/li>\n<li>Stisknut\u00edm kl\u00e1vesy Enter zobraz\u00edte sou\u010det, nap\u0159\u00edklad 32 v bu\u0148ce I2.<\/li>\n<li>Chcete-li to roz\u0161\u00ed\u0159it do v\u0161ech kategori\u00ed, pou\u017eijte: <code>=ARRAYFORMULA(SUMIF(F2:F, H2:H, D2:D))<\/code>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt=\"Pou\u017eit\u00ed SUMIF s ARRAYFORMULA\" class=\"wp-image\" decoding=\"async\" height=\"584\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/11\/image-199-1.webp\" title=\"Pou\u017eit\u00ed SUMIF s ARRAYFORMULA\" width=\"1038\"\/><\/figure>\n<h2 id=\"things-to-know\">D\u016fle\u017eit\u00e9 \u00favahy<\/h2>\n<ul>\n<li>Ujist\u011bte se, \u017ee v\u0161echna pou\u017eit\u00e1 pole maj\u00ed stejnou velikost, abyste p\u0159ede\u0161li chyb\u00e1m.<\/li>\n<li>M\u016f\u017eete pou\u017e\u00edt <code>Ctrl + Shift + Enter<\/code>zkratku pro automatick\u00e9 vlo\u017een\u00ed &#8216;ARRAYFORMULA&#8217; do va\u0161eho vzorce.<\/li>\n<li>Zm\u011bny proveden\u00e9 v jednotliv\u00fdch bu\u0148k\u00e1ch v ARRAYFORMULA ovlivn\u00ed v\u0161echny bu\u0148ky v ur\u010den\u00e9m rozsahu.<\/li>\n<li>V\u0161imn\u011bte si, \u017ee zat\u00edmco ARRAYFORMULA pracuje s r\u016fzn\u00fdmi funkcemi, nepodporuje funkce <strong>Query<\/strong> nebo <strong>Filter<\/strong> .<\/li>\n<\/ul>\n<p>Podrobn\u011bj\u0161\u00ed pokyny k pou\u017e\u00edv\u00e1n\u00ed ARRAYFORMULA v Tabulk\u00e1ch Google naleznete v <a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-array-formula-in-google-sheets\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">tomto zdroji<\/a> .<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Odemknut\u00ed s\u00edly ARRAYFORMULA v Tabulk\u00e1ch Google Funkce ARRAYFORMULA v Tabulk\u00e1ch Google m\u011bn\u00ed hru a umo\u017e\u0148uje u\u017eivatel\u016fm bez n\u00e1mahy pou\u017e\u00edt jeden vzorec na cel\u00fd sloupec. Tato v\u00fdkonn\u00e1 funkce eliminuje pot\u0159ebu zdlouhav\u00e9ho kop\u00edrov\u00e1n\u00ed, vkl\u00e1d\u00e1n\u00ed nebo p\u0159etahov\u00e1n\u00ed vzorc\u016f p\u0159es v\u00edce bun\u011bk, tak\u017ee manipulace s daty je rychlej\u0161\u00ed a efektivn\u011bj\u0161\u00ed. A\u0165 u\u017e po\u010d\u00edt\u00e1te sou\u010dty nebo prov\u00e1d\u00edte slo\u017eit\u00e9 operace, ARRAYFORMULA [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[806,126,173],"class_list":["post-5455","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google-sheets","tag-microsoft","tag-web"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=5455"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5455\/revisions"}],"predecessor-version":[{"id":5456,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5455\/revisions\/5456"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=5455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=5455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=5455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}