{"id":20569,"date":"2026-02-19T16:53:17","date_gmt":"2026-02-19T16:53:17","guid":{"rendered":"https:\/\/undetectable.ai/blog\/?p=20569"},"modified":"2026-03-04T19:23:59","modified_gmt":"2026-03-04T19:23:59","slug":"tabulkove-vzorce","status":"publish","type":"post","link":"https:\/\/undetectable.ai/blog\/cs\/tabulkove-vzorce\/","title":{"rendered":"Vzorce pro tabulkov\u00fd procesor Excel a Google, kter\u00e9 si nem\u016f\u017eete dovolit ignorovat"},"content":{"rendered":"<p>Pokud pou\u017e\u00edv\u00e1te Excel\/Google Sheets jako sou\u010d\u00e1st sv\u00e9 ka\u017edodenn\u00ed pr\u00e1ce, existuje n\u011bkolik velmi u\u017eite\u010dn\u00fdch vzorc\u016f, ke kter\u00fdm se budete r\u00e1di vracet, pokud se je jednou nau\u010d\u00edte.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Existuje pravd\u011bpodobn\u011b v\u00edce ne\u017e sto r\u016fzn\u00fdch tabulkov\u00fdch vzorc\u016f, kter\u00e9 funguj\u00ed pro r\u016fzn\u00e9 typy v\u00fdpo\u010dt\u016f.<\/p>\n\n\n\n<p>M\u00fdm c\u00edlem v tomto blogu je hovo\u0159it o t\u011bch nejjednodu\u0161\u0161\u00edch, kter\u00e9 tvo\u0159\u00ed z\u00e1klad v\u0161ech pokro\u010dil\u00fdch v\u00fdpo\u010dt\u016f, kter\u00e9 se m\u016f\u017eete nau\u010dit pozd\u011bji.&nbsp;<\/p>\n\n\n\n<p>Nejprve si projdeme n\u011bkolik z\u00e1kladn\u00edch p\u0159\u00edkaz\u016f pro aritmetick\u00e9 v\u00fdpo\u010dty a pot\u00e9 v\u00e1s sezn\u00e1m\u00edm s n\u011bkolika zp\u016fsoby, jak m\u016f\u017eete prov\u00e1d\u011bt pokro\u010dilej\u0161\u00ed anal\u00fdzy.<\/p>\n\n\n\n<p>Pat\u0159\u00ed mezi n\u011b p\u0159\u00edkazy IF, VLOOKUP, INDEX, MATCH atd.&nbsp;<\/p>\n\n\n\n<p>A je to jednodu\u0161\u0161\u00ed, ne\u017e si mysl\u00edte!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-text-align-center\"><strong>Kl\u00ed\u010dov\u00e9 poznatky<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aplikace Excel a Tabulky Google maj\u00ed mnoho vestav\u011bn\u00fdch p\u0159\u00edkaz\u016f vzorc\u016f, kter\u00e9 jsou u\u017eite\u010dn\u00e9 pro prov\u00e1d\u011bn\u00ed v\u00fdpo\u010dt\u016f.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMA, PR\u016eM\u011aR, PO\u010cET, VLOOKUP, INDEX a MATCH jsou n\u011bkter\u00e9 vzorce, kter\u00e9 mohou pomoci p\u0159i ka\u017edodenn\u00edch v\u00fdpo\u010dtech. M\u016f\u017eete si s nimi tak\u00e9 pohr\u00e1t zaveden\u00edm podm\u00edn\u011bn\u00e9 logiky.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>P\u0159i psan\u00ed vzorce nesm\u00ed doj\u00edt k chyb\u00e1m, jinak se nedo\u010dk\u00e1te v\u00fdsledk\u016f. Dbejte zejm\u00e9na na to, abyste se vyhnuli kruhov\u00fdm odkaz\u016fm a zabr\u00e1nili tomu, aby se Excel dostal do nekone\u010dn\u00e9 v\u00fdpo\u010detn\u00ed smy\u010dky.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Co je to p\u0159esn\u011b vzorec tabulkov\u00e9ho procesoru?<\/h2>\n\n\n\n<p>P\u0159\u00edkazy, pomoc\u00ed kter\u00fdch m\u016f\u017eete prov\u00e1d\u011bt v\u00fdpo\u010dty dat, se naz\u00fdvaj\u00ed vzorce tabulkov\u00e9ho procesoru.<\/p>\n\n\n\n<p>Microsoft Excel i Dokumenty Google jsou vybaveny takov\u00fdmi p\u0159\u00edkazy, co\u017e je \u010d\u00e1ste\u010dn\u011b d\u016fvod, pro\u010d jsou z\u00e1kladn\u00edmi n\u00e1stroji na ka\u017ed\u00e9m pracovi\u0161ti.&nbsp;<\/p>\n\n\n\n<p>P\u0159ed ka\u017ed\u00fdm vzorcem zapsan\u00fdm v aplikaci Excel je znak (=). Je to znamen\u00ed, \u017ee Excel m\u00e1 n\u00e1sleduj\u00edc\u00ed text pova\u017eovat za vzorec pro proveden\u00ed po\u017eadovan\u00e9ho v\u00fdpo\u010dtu, nikoli za prost\u00fd textov\u00fd z\u00e1pis.<\/p>\n\n\n\n<p>Krom\u011b pou\u017eit\u00ed vzorc\u016f pro data v tabulk\u00e1ch Tabulky Google nebo Excel uv\u00e1d\u00edme n\u011bkolik d\u016fvod\u016f, pro\u010d maj\u00ed aplikace Excel a Tabulky Google stovky p\u0159\u00edkaz\u016f vzorc\u016f:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rychle automatizuje v\u00fdpo\u010dty<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Ka\u017ed\u00fd z n\u00e1s pot\u0159ebuje prov\u00e1d\u011bt z\u00e1kladn\u00ed v\u00fdpo\u010dty, jako je aritmetika nebo v\u00fdpo\u010det pr\u016fm\u011br\u016f, bez ohledu na povahu sv\u00e9 pr\u00e1ce.&nbsp;<\/p>\n\n\n\n<p>Pokud je va\u0161e pr\u00e1ce n\u00e1ro\u010dn\u00e1 na data, vy\u017eadujete rozs\u00e1hlej\u0161\u00ed v\u00fdpo\u010dty s mnohem vy\u0161\u0161\u00ed frekvenc\u00ed.&nbsp;<\/p>\n\n\n\n<p>Je velmi v\u00fdhodn\u00e9, kdy\u017e m\u016f\u017eete tyto v\u00fdpo\u010dty prov\u00e1d\u011bt v tabulkov\u00e9m procesoru, kde jsou data ulo\u017eena, a nemus\u00edte je importovat do kalkula\u010dky.<\/p>\n\n\n\n<p>Vzorec m\u016f\u017eete tak\u00e9 nastavit pouze jednou a bude pokra\u010dovat pro libovoln\u00fd po\u010det \u0159\u00e1dk\u016f nebo zadan\u00fdch dat.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sni\u017euje po\u010det manu\u00e1ln\u00edch chyb<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Exportov\u00e1n\u00ed dat do aplikace kalkula\u010dky je nejen \u010dasov\u011b n\u00e1ro\u010dn\u00e9, ale tak\u00e9 se p\u0159i n\u011bm mohou vyskytnout chyby. Sta\u010d\u00ed jeden chybn\u00fd \u00fadaj a cel\u00fd v\u00e1\u0161 v\u00fdpo\u010det je nespolehliv\u00fd.<\/p>\n\n\n\n<p>Ani po n\u011bkolikan\u00e1sobn\u00e9 korektu\u0159e si nem\u016f\u017eete b\u00fdt jisti, zda jste v\u0161echny hodnoty zadali spr\u00e1vn\u011b.&nbsp;<\/p>\n\n\n\n<p>Spu\u0161t\u011bn\u00ed tabulkov\u00e9ho vzorce sni\u017euje po\u010det t\u011bchto chyb.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Logicky propojuje data<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Pomoc\u00ed v\u00fdpo\u010dt\u016f m\u016f\u017eete mnohem logi\u010dt\u011bji zpracov\u00e1vat soubory dat. Se\u0159a\u010fte data, filtrujte je, prove\u010fte anal\u00fdzu a l\u00e9pe pochop\u00edte, \u010demu v\u0161echna ta \u010d\u00edsla v jednotliv\u00fdch bu\u0148k\u00e1ch tabulky odpov\u00eddaj\u00ed.&nbsp;<\/p>\n\n\n\n<p>Skv\u011ble se hod\u00ed pro:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sestavov\u00e1n\u00ed rozpo\u010dtu&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veden\u00ed osobn\u00ed nebo firemn\u00ed finan\u010dn\u00ed evidence&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>U\u010ditel\u00e9, kte\u0159\u00ed cht\u011bj\u00ed m\u00edt z\u00e1znam o \u00fakolech\/v\u00fdkonech sv\u00fdch student\u016f p\u0159i zkou\u0161k\u00e1ch.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00fdzkumn\u00e1 data&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00fdpo\u010det v\u00fdnos\u016f z investic&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>A\u0165 u\u017e pot\u0159ebujete zn\u00e1t vzorce tabulkov\u00e9ho procesoru Google, nebo chcete seznam vzorc\u016f tabulkov\u00e9ho procesoru Excel, najdete je v dal\u0161\u00ed \u010d\u00e1sti.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Z\u00e1kladn\u00ed vzorce, kter\u00e9 pot\u0159ebuje ka\u017ed\u00fd u\u017eivatel<\/h2>\n\n\n\n<p>Aplikace Excel i Tabulky Google obsahuj\u00ed stovky vzorc\u016f, kter\u00e9 prov\u00e1d\u011bj\u00ed r\u016fzn\u00e9 v\u00fdpo\u010dty. Pokud se je chcete nau\u010dit v\u0161echny, zabere v\u00e1m to n\u011bkolik m\u011bs\u00edc\u016f. N\u00ed\u017ee jsem v\u0161ak popsal n\u011bkolik velmi u\u017eite\u010dn\u00fdch.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUMA pro sou\u010dty<\/strong><\/li>\n<\/ul>\n\n\n\n<p>P\u0159\u00edkaz SUM() slou\u017e\u00ed k se\u010dten\u00ed v\u0161ech vybran\u00fdch bun\u011bk. Aby fungoval, mus\u00ed b\u00fdt v bu\u0148ce samoz\u0159ejm\u011b \u010d\u00edseln\u00e1 hodnota. Vzorec nebude fungovat v \u017e\u00e1dn\u00e9 jin\u00e9 ne\u017e \u010d\u00edseln\u00e9 bu\u0148ce.&nbsp;<\/p>\n\n\n\n<p>V z\u00e1vorce je t\u0159eba zadat prvn\u00ed a posledn\u00ed bu\u0148ku segmentu tabulky, kter\u00fd chcete p\u0159idat, odd\u011blenou dvojte\u010dkou.&nbsp;<\/p>\n\n\n\n<p>Pokud tedy chci se\u010d\u00edst obsah \u0159\u00e1dk\u016f 3 a\u017e 7 v prvn\u00edm sloupci, nap\u00ed\u0161u vzorec takto: SUM(A3:A7). Vzorec funguje i ve v\u00edce \u0159\u00e1dc\u00edch.<\/p>\n\n\n\n<p>Tento vzorec z\u016fst\u00e1v\u00e1 stejn\u00fd pro Tabulky Google i Excel.<\/p>\n\n\n\n<p>Pod\u00edvejte se na tento p\u0159\u00edklad:&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"630\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg\" alt=\"\" class=\"wp-image-20576\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg 969w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-300x195.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-768x499.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-18x12.jpg 18w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/figure><\/div>\n\n\n<p>Krom\u011b nejjednodu\u0161\u0161\u00ed funkce SUM m\u016f\u017eete prov\u00e1d\u011bt tak\u00e9 n\u00e1sleduj\u00edc\u00ed typy s\u010d\u00edt\u00e1n\u00ed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMIF: S\u010d\u00edt\u00e1n\u00ed \u010d\u00edsel v rozsahu, kter\u00e1 spl\u0148uj\u00ed jednu podm\u00ednku<br><\/li>\n\n\n\n<li>SUMIFS: S\u010d\u00edt\u00e1n\u00ed \u010d\u00edsel v rozsahu, kter\u00e1 spl\u0148uj\u00ed v\u00edce podm\u00ednek<br><\/li>\n\n\n\n<li>SUMPRODUKT: N\u00e1soben\u00ed odpov\u00eddaj\u00edc\u00edch hodnot v pol\u00edch a n\u00e1sledn\u00e9 se\u010dten\u00ed v\u00fdsledk\u016f<br><\/li>\n\n\n\n<li>SUMSQ: S\u010d\u00edt\u00e1n\u00ed \u010dtverc\u016f \u010d\u00edsel v dan\u00e9m rozsahu<br><\/li>\n\n\n\n<li>SUMX2MY2: Se\u010dte v\u00fdsledek (x\u00b2 - y\u00b2) pro odpov\u00eddaj\u00edc\u00ed hodnoty ve dvou rozsaz\u00edch.<br><\/li>\n\n\n\n<li>SUMX2PY2: Se\u010dte v\u00fdsledek (x\u00b2 + y\u00b2) pro odpov\u00eddaj\u00edc\u00ed hodnoty ve dvou rozsaz\u00edch.<br><\/li>\n\n\n\n<li>SUMXMY2: S\u010d\u00edt\u00e1n\u00ed \u010dtverc\u016f rozd\u00edl\u016f (x - y)\u00b2 pro dva rozsahy<br><\/li>\n\n\n\n<li>DSUM: P\u0159id\u00e1n\u00ed hodnot do sloupce, kter\u00e9 spl\u0148uj\u00ed krit\u00e9ria definovan\u00e1 v datab\u00e1zov\u00e9 tabulce.<br><\/li>\n\n\n\n<li>IMSUM: S\u010d\u00edt\u00e1n\u00ed komplexn\u00edch \u010d\u00edsel.<br><\/li>\n\n\n\n<li>SERIESSUM: Vypo\u010d\u00edtejte sou\u010det mocninn\u00e9 \u0159ady pomoc\u00ed dan\u00fdch koeficient\u016f.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg\" alt=\"\" class=\"wp-image-20577\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-300x148.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-768x378.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1536x756.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-18x9.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>PR\u016eM\u011aR pro vhledy<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Vzorec AVERAGE() slou\u017e\u00ed k v\u00fdpo\u010dtu pr\u016fm\u011bru dan\u00e9 sady bun\u011bk v tabulce.&nbsp;<\/p>\n\n\n\n<p>Pr\u00e1ce je op\u011bt t\u00e9m\u011b\u0159 stejn\u00e1. Do z\u00e1vorek vlo\u017e\u00edte prvn\u00ed a posledn\u00ed \u010d\u00edslo bu\u0148ky odd\u011blen\u00e9 dvojte\u010dkou, nap\u0159. AVERAGE(E2:E11), a z\u00edsk\u00e1te pr\u016fm\u011br pro vybran\u00e9 bu\u0148ky.<\/p>\n\n\n\n<p>Vzorec pro v\u00fdpo\u010det pr\u016fm\u011bru je op\u011bt stejn\u00fd v aplikaci Excel i v tabulk\u00e1ch Google.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"501\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg\" alt=\"\" class=\"wp-image-20578\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg 847w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-300x177.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-768x454.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-18x12.jpg 18w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure><\/div>\n\n\n<p>Drobn\u00e9 odchylky ve vzorci PR\u016eM\u011aR v\u00e1m mohou pomoci s podm\u00edn\u011bn\u00fdmi v\u00fdpo\u010dty, nap\u0159\u00edklad:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PR\u016eM\u011aR: V\u00fdpo\u010det aritmetick\u00e9ho pr\u016fm\u011bru \u010d\u00edsel v rozsahu<br><\/li>\n\n\n\n<li>AVERAGEA: Pou\u017eijte, pokud chcete z\u00edskat pr\u016fm\u011br, v\u010detn\u011b \u010d\u00edsel, textu a logick\u00fdch hodnot.<br><\/li>\n\n\n\n<li>PR\u016eM\u011aRN\u00c1 HODNOTAIF: Tento p\u0159\u00edkaz slou\u017e\u00ed k ur\u010den\u00ed pr\u016fm\u011bru \u010d\u00edsel, kter\u00e1 spl\u0148uj\u00ed jednu podm\u00ednku.<br><\/li>\n\n\n\n<li>AVERAGEIFS: Tato funkce vypo\u010d\u00edt\u00e1 pr\u016fm\u011br \u010d\u00edsel, kter\u00e1 spl\u0148uj\u00ed v\u00edce podm\u00ednek.<br><\/li>\n\n\n\n<li>DAVERAGE: Vypo\u010d\u00edt\u00e1 pr\u016fm\u011br hodnot ve sloupci datab\u00e1ze, kter\u00e9 spl\u0148uj\u00ed zadan\u00e1 krit\u00e9ria.<br><\/li>\n\n\n\n<li>COUNT pro sledov\u00e1n\u00ed polo\u017eek<\/li>\n<\/ul>\n\n\n\n<p>Tento p\u0159\u00edkaz je u\u017eite\u010dn\u00fd pro v\u00fdpo\u010det po\u010dtu bun\u011bk v tabulce, kter\u00e9 obsahuj\u00ed \u010d\u00edseln\u00e9 \u00fadaje.&nbsp;<\/p>\n\n\n\n<p>Nem\u00e1 smysl ji pou\u017e\u00edvat, pokud jsou va\u0161e data omezena pouze na n\u011bkolik \u0159\u00e1dk\u016f, ale pokud m\u00e1te stovky \u0159\u00e1dk\u016f dat a chcete v\u011bd\u011bt, kolik z nich jsou \u010d\u00edseln\u00e9 hodnoty, s\u00e1hnete po t\u00e9to funkci.<\/p>\n\n\n\n<p>Podobn\u00fdm zp\u016fsobem se p\u00ed\u0161e tak\u00e9, tj. za\u010d\u00edn\u00e1 se znakem =, pak se uvede p\u0159\u00edkaz COUNT, otev\u0159e se z\u00e1vorka, uvede se prvn\u00ed a posledn\u00ed bu\u0148ka odd\u011blen\u00e1 dvojte\u010dkou a z\u00e1vorka se uzav\u0159e.<\/p>\n\n\n\n<p>Vzorec je stejn\u00fd v Tabulk\u00e1ch Google i v aplikaci Excel.<\/p>\n\n\n\n<p>Nap\u0159\u00edklad, <strong>=COUNT(E1:E100)<\/strong><\/p>\n\n\n\n<p>Stejn\u011b jako vzorce SUMA a PR\u016eM\u011aR lze i vzorec PO\u010cET pou\u017e\u00edt n\u011bkolika r\u016fzn\u00fdmi zp\u016fsoby, nap\u0159.,&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNTA: Po\u010d\u00edt\u00e1n\u00ed bun\u011bk, kter\u00e9 nejsou pr\u00e1zdn\u00e9 (\u010d\u00edsla, text nebo hodnoty).<br><\/li>\n\n\n\n<li>COUNTBLANK: Po\u010d\u00edt\u00e1 pouze pr\u00e1zdn\u00e9 bu\u0148ky v rozsahu.<br><\/li>\n\n\n\n<li>COUNTIF: Po\u010d\u00edt\u00e1 bu\u0148ky, kter\u00e9 spl\u0148uj\u00ed jednu podm\u00ednku<br><\/li>\n\n\n\n<li>COUNTIFS: Slou\u017e\u00ed k po\u010d\u00edt\u00e1n\u00ed bun\u011bk, kter\u00e9 spl\u0148uj\u00ed v\u00edce podm\u00ednek.<br><\/li>\n\n\n\n<li>DCOUNT: Tato funkce po\u010d\u00edt\u00e1 \u010d\u00edseln\u00e9 hodnoty ve sloupci datab\u00e1ze, kter\u00e9 spl\u0148uj\u00ed zadan\u00e1 krit\u00e9ria.<br><\/li>\n\n\n\n<li>DCOUNTA: Slou\u017e\u00ed k po\u010d\u00edt\u00e1n\u00ed nepr\u00e1zdn\u00fdch hodnot ve sloupci datab\u00e1ze, kter\u00e9 spl\u0148uj\u00ed zadan\u00e1 krit\u00e9ria.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"468\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg\" alt=\"\" class=\"wp-image-20579\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-300x137.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-768x351.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1536x702.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-18x8.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Pokro\u010dil\u00e9 vzorce pro anal\u00fdzu dat<\/h2>\n\n\n\n<p>Pro v\u011bt\u0161inu u\u017eivatel\u016f budou vzorce, kter\u00e9 jsem uvedl d\u0159\u00edve, v\u00edce ne\u017e dosta\u010duj\u00edc\u00ed. N\u011bkter\u00e9 vzorce jsou v\u0161ak pot\u0159ebn\u00e9 pro pokro\u010dil\u00e9 v\u00fdpo\u010dty a velmi se hod\u00ed, pokud va\u0161e pr\u00e1ce zahrnuje anal\u00fdzu dat.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>VLOOKUP pro vyhled\u00e1v\u00e1n\u00ed<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Vzorec VLOOKUP slou\u017e\u00ed k vyhled\u00e1n\u00ed hodnoty v tabulce a vr\u00e1cen\u00ed souvisej\u00edc\u00edch informac\u00ed ze stejn\u00e9ho \u0159\u00e1dku.<\/p>\n\n\n\n<p>Zjednodu\u0161en\u011b \u0159e\u010deno, kdy\u017e zad\u00e1te VLOOKUP, vyzvete tabulkov\u00fd procesor, aby vyhledal hodnotu v prvn\u00edm sloupci tabulky a pot\u00e9 v\u00e1m poskytl hodnotu z jin\u00e9ho sloupce v tomto \u0159\u00e1dku.<\/p>\n\n\n\n<p>Pokud jsou v na\u0161em vzorov\u00e9m listu ve sloupci A ID produkt\u016f a ve sloupci C cena za jednotku, m\u016f\u017eeme pomoc\u00ed funkce VLOOKUP vyhledat ID ur\u010dit\u00e9ho produktu a z\u00edskat jeho cenu ze sloupce C.&nbsp;<\/p>\n\n\n\n<p>Zap\u00ed\u0161e se jako VLOOKUP(\u201cP-1001\u201d, A:C, 3, FALSE).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"522\" height=\"290\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg\" alt=\"\" class=\"wp-image-20581\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg 522w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-300x167.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-18x10.jpg 18w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>P\u0159\u00edkazy IF pro logiku<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Funkce IF slou\u017e\u00ed k logick\u00e9mu rozhodov\u00e1n\u00ed v tabulkov\u00e9m procesoru. Jednodu\u0161e \u0159\u00edk\u00e1 listu, co m\u00e1 ud\u011blat, kdy\u017e je podm\u00ednka pravdiv\u00e1, a co m\u00e1 ud\u011blat, kdy\u017e je nepravdiv\u00e1.<\/p>\n\n\n\n<p>P\u0159\u00edkaz IF se p\u00ed\u0161e tak, \u017ee se na za\u010d\u00e1tku uvede znak =, p\u0159\u00edkaz IF, otev\u0159ou se z\u00e1vorky a pak se pop\u00ed\u0161e podm\u00ednka.<\/p>\n\n\n\n<p>Po n\u011bm p\u0159ipojte \u010d\u00e1rku a uve\u010fte, co m\u00e1 list ud\u011blat, pokud je podm\u00ednka spln\u011bna. N\u00e1sleduje dal\u0161\u00ed \u010d\u00e1rka a informace o tom, co se m\u00e1 st\u00e1t, pokud p\u0159\u00edkaz spln\u011bn nebude.<\/p>\n\n\n\n<p>Pokud si nap\u0159\u00edklad p\u0159edstav\u00edme list s v\u00fdsledky student\u016f a chceme zadat podm\u00ednku, \u017ee v\u00fdsledek 50 a v\u00edce bod\u016f je vyhovuj\u00edc\u00ed a m\u00e9n\u011b ne\u017e 50 bod\u016f je nevyhovuj\u00edc\u00ed, m\u016f\u017eeme pou\u017e\u00edt logiku IF.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg\" alt=\"\" class=\"wp-image-20582\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-300x170.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-768x436.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-18x10.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic.jpg 1162w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Nap\u00ed\u0161ete to takto: =IF(A1&gt;=50, \u201cvyhov\u011bl\u201d, \u201cnevyhov\u011bl\u201d)<\/p>\n\n\n\n<p>List vyhled\u00e1 hodnotu v bu\u0148ce, a pokud je v\u011bt\u0161\u00ed ne\u017e 50, zobraz\u00ed se, \u017ee student pro\u0161el. V opa\u010dn\u00e9m p\u0159\u00edpad\u011b bude uvedeno, \u017ee neprosp\u011bl.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>INDEX &amp; MATCH pro vyhled\u00e1v\u00e1n\u00ed<\/strong><\/li>\n<\/ul>\n\n\n\n<p>INDEX a MATCH se pou\u017e\u00edvaj\u00ed spole\u010dn\u011b k vyhled\u00e1v\u00e1n\u00ed informac\u00ed v tabulce flexibiln\u011bj\u0161\u00edm zp\u016fsobem ne\u017e vzorec LOOKUP.&nbsp;<\/p>\n\n\n\n<p>Funkce MATCH slou\u017e\u00ed k nalezen\u00ed pozice hodnoty v \u0159\u00e1dku nebo sloupci. Funkce MATCH slou\u017e\u00ed k vyhled\u00e1n\u00ed hodnoty v tabulce a nevrac\u00ed samotnou hodnotu. Vr\u00e1t\u00ed \u010d\u00edslo, kter\u00e9 p\u0159edstavuje m\u00edsto, kde se hodnota vyskytuje.<\/p>\n\n\n\n<p>Pokud je nap\u0159\u00edklad ID produktu p\u00e1tou polo\u017ekou v seznamu, funkce MATCH vr\u00e1t\u00ed 5.<\/p>\n\n\n\n<p>Funkce INDEX pou\u017e\u00edv\u00e1 toto \u010d\u00edslo pozice k vr\u00e1cen\u00ed hodnoty z ur\u010dit\u00e9ho m\u00edsta v tabulce nebo sloupci. Jednodu\u0161e tedy na\u010dte jakoukoli hodnotu, kter\u00e1 existuje na zadan\u00e9m \u0159\u00e1dku.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"336\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg\" alt=\"\" class=\"wp-image-20583\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg 325w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-290x300.jpg 290w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-12x12.jpg 12w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Tipy, jak se vyhnout b\u011b\u017en\u00fdm chyb\u00e1m ve vzorc\u00edch<\/h2>\n\n\n\n<p>Jak jste si ji\u017e mohli v\u0161imnout, Excel i Tabulky Google vy\u017eaduj\u00ed zad\u00e1v\u00e1n\u00ed vzorc\u016f s p\u0159esnost\u00ed 100%.<\/p>\n\n\n\n<p>Jak\u00e9koli chyby v z\u00e1pisu vzorce v\u00e1m nep\u0159inesou v\u00fdsledky, pouze se zobraz\u00ed chybov\u00e1 zpr\u00e1va s n\u00e1pisem #N\/A.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"493\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg\" alt=\"\" class=\"wp-image-20584\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg 678w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-300x218.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-18x12.jpg 18w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n<p>Zde je n\u011bkolik tip\u016f, kter\u00e9 v\u00e1m pomohou vyhnout se t\u00e9to chybov\u00e9 zpr\u00e1v\u011b.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pe\u010dliv\u011b zkontrolujte z\u00e1vorky<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Vzorec mus\u00ed b\u00fdt zaps\u00e1n p\u0159esn\u011b ve v\u00fd\u0161e popsan\u00e9m form\u00e1tu. Pokud byste n\u00e1hodou nechali z\u00e1vorky otev\u0159en\u00e9 nebo jen popsali rozsah bun\u011bk bez z\u00e1vorek, data se v\u00e1m nevypo\u010d\u00edtaj\u00ed.&nbsp;<\/p>\n\n\n\n<p>V\u017edy se ujist\u011bte, \u017ee m\u00e1te otev\u0159en\u00e9 i uzav\u00edrac\u00ed z\u00e1vorky dob\u0159e nasazen\u00e9. Dbejte tak\u00e9 na to, aby byla prvn\u00ed a posledn\u00ed bu\u0148ka rozsahu odd\u011blena dvojte\u010dkou.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Datov\u00e9 typy hodinek<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Tabulkov\u00e9 vzorce pracuj\u00ed nejl\u00e9pe pouze s ur\u010dit\u00fdmi typy dat. Nap\u0159\u00edklad u dat, kter\u00e1 nelze kvantifikovat, tj. u popisn\u00fdch forem dat, nelze o\u010dek\u00e1vat st\u0159edn\u00ed hodnotu.&nbsp;<\/p>\n\n\n\n<p>P\u0159i ka\u017ed\u00e9m vkl\u00e1d\u00e1n\u00ed vzorc\u016f dvakr\u00e1t zkontrolujte data v bu\u0148k\u00e1ch, abyste nezadali neplatn\u00fd rozsah bun\u011bk.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Vyhn\u011bte se kruhov\u00fdm odkaz\u016fm<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Kruhov\u00fd odkaz znamen\u00e1, \u017ee se tabulka vrac\u00ed zp\u011bt do sv\u00e9 bu\u0148ky, kde je pops\u00e1na. Vytv\u00e1\u0159\u00ed nekone\u010dnou cirkula\u010dn\u00ed smy\u010dku, ve kter\u00e9 nelze z\u00edskat odpov\u011b\u010f a m\u00edsto n\u00ed se zobraz\u00ed pouze chybov\u00e1 zpr\u00e1va.<\/p>\n\n\n\n<p>Pokud nap\u0159\u00edklad zad\u00e1te SUM(A1:A10) do bu\u0148ky A10, vytvo\u0159\u00edte kruhovou smy\u010dku, ve kter\u00e9 se bude muset neust\u00e1le p\u0159i\u010d\u00edtat jak\u00e1koli hodnota se\u010dten\u00e1 v bu\u0148ce A10, a tento proces nikdy neskon\u010d\u00ed.<\/p>\n\n\n\n<p>Vzorec pot\u0159ebuje zn\u00e1t sv\u016fj vlastn\u00ed v\u00fdsledek, aby zjistil hodnotu bu\u0148ky A10.<\/p>\n\n\n\n<p>V\u017edy se ujist\u011bte, \u017ee bu\u0148ka, do kter\u00e9 jste vzorec tabulky zadali, nen\u00ed sou\u010d\u00e1st\u00ed samotn\u00e9ho rozsahu bun\u011bk vzorce.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kombinace vzorc\u016f pro lep\u0161\u00ed \u00fa\u010dinnost<\/h2>\n\n\n\n<p>Kombinov\u00e1n\u00ed vzorc\u016f v tabulk\u00e1ch umo\u017e\u0148uje efektivn\u011bji \u0159e\u0161it slo\u017eit\u00e9 probl\u00e9my. P\u0159i pou\u017eit\u00ed jednoduch\u00fdch vzorc\u016f, o kter\u00fdch jsem mluvil d\u0159\u00edve, budete po\u010d\u00edtat postupn\u011b v mnoha bu\u0148k\u00e1ch. <\/p>\n\n\n\n<p>V kombinovan\u00e9m vzorci m\u016f\u017eete vno\u0159it v\u00edce v\u00fdpo\u010dt\u016f tak, \u017ee jeden vzorec p\u0159\u00edmo navazuje na druh\u00fd.<\/p>\n\n\n\n<p>M\u016f\u017eete nap\u0159\u00edklad kombinovat IF se SUM a s\u010d\u00edtat tak hodnoty, kter\u00e9 spl\u0148uj\u00ed pouze ur\u010dit\u00e9 podm\u00ednky.<\/p>\n\n\n\n<p>M\u016f\u017eete tak\u00e9 kombinovat COUNT nebo AVERAGE s podm\u00ednkami pro p\u0159esn\u011bj\u0161\u00ed anal\u00fdzu dat.<\/p>\n\n\n\n<p>Kombinov\u00e1n\u00ed vzorc\u016f v\u0161ak zpo\u010d\u00e1tku nen\u00ed snadn\u00e9. Existuje skute\u010dn\u00e1 k\u0159ivka u\u010den\u00ed, a pokud se vrhnete do slo\u017eit\u00fdch vno\u0159en\u00fdch vzorc\u016f, ani\u017e byste n\u011bkolikr\u00e1t pou\u017eili ty jednoduch\u00e9, skon\u010d\u00edte zmaten\u00ed.<\/p>\n\n\n\n<p>Proto v\u017edy nejprve procvi\u010dujte jednoduch\u00e9 vzorce. Jakmile se s nimi nau\u010d\u00edte pracovat, postupn\u011b je roz\u0161i\u0159ujte kombinac\u00ed dvou funkc\u00ed, pak t\u0159\u00ed a nakonec i pokro\u010dilej\u0161\u00edch sestav.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pou\u017e\u00edv\u00e1n\u00ed vzorc\u016f pro \u00falohy z re\u00e1ln\u00e9ho sv\u011bta<\/h2>\n\n\n\n<p>Jakmile si tyto vzorce osvoj\u00edte, za\u010dnete si v\u0161\u00edmat, jak \u010dasto se vztahuj\u00ed na v\u011bci, kter\u00e9 u\u017e d\u011bl\u00e1te.<\/p>\n\n\n\n<p>Nap\u0159\u00edklad:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Majitel mal\u00e9 firmy m\u016f\u017ee pou\u017e\u00edt vzorec <strong>SUMIF<\/strong> sledovat v\u00fddaje podle kategori\u00ed<\/li>\n\n\n\n<li>Nebo m\u016f\u017ee u\u010ditel kombinovat <strong>IF<\/strong> s <strong>COUNTIF<\/strong> funkce pro ozna\u010den\u00ed student\u016f, kte\u0159\u00ed zaost\u00e1vaj\u00ed v pln\u011bn\u00ed \u00fakol\u016f.<\/li>\n\n\n\n<li>Stejn\u011b tak je tomu u freelancer\u016f, kte\u0159\u00ed spravuj\u00ed faktury klient\u016f. Mohou pou\u017e\u00edt jednoduch\u00fd <strong>VLOOKUP<\/strong> vyt\u00e1hnout sazby klient\u016f z hlavn\u00edho seznamu bez nutnosti ru\u010dn\u00edho proch\u00e1zen\u00ed \u0159\u00e1dk\u016f.<\/li>\n<\/ul>\n\n\n\n<p>Jde o to, \u017ee v\u011bd\u011bt, kter\u00fd vzorec se hod\u00ed pro va\u0161i konkr\u00e9tn\u00ed situaci, je t\u00e9m\u011b\u0159 polovina \u00fasp\u011bchu. A to je p\u0159esn\u011b ta oblast, kde je Undetectable <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">Chatbot s um\u011blou inteligenc\u00ed<\/a> m\u016f\u017ee b\u00fdt va\u0161\u00edm pr\u016fvodcem.&nbsp;<\/p>\n\n\n\n<p>M\u016f\u017eete jednodu\u0161e popsat, co se sna\u017e\u00edte ud\u011blat, a program v\u00e1m navrhne spr\u00e1vn\u00fd vzorec pro v\u00e1\u0161 \u00fakol.<\/p>\n\n\n\n<p>Nyn\u00ed m\u00e1te spolupracovn\u00edka, kter\u00fd um\u00ed pracovat s tabulkami, na kter\u00e9ho se m\u016f\u017eete obr\u00e1tit, kdykoli se zaseknete, a to nejen v p\u0159\u00edpad\u011b dotaz\u016f v Excelu nebo tabulkov\u00e9m procesoru Google.<\/p>\n\n\n\n<p>N\u00ed\u017ee se pod\u00edvejte, jak m\u016f\u017ee n\u00e1\u0161 detektor um\u011bl\u00e9 inteligence a n\u00e1stroj Humanizer vylep\u0161it v\u00e1\u0161 obsah!<\/p>\n\n\n\n<div id=\"uai-widget\" data-affiliate-link=\"https:\/\/undetectable.ai\/?_by=hi4km\"><script>var js = document.createElement(\"script\");js.async = true;js.src = \"https:\/\/widget.undetectable.ai\/js\/widget-loader.js?t=\"+Date.now();document.getElementsByTagName(\"head\")[0].appendChild(js);<\/script><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Z\u00e1v\u011bre\u010dn\u00e9 my\u0161lenky<\/h2>\n\n\n\n<p>Douf\u00e1m, \u017ee v\u00e1m tento \u010dl\u00e1nek pomohl nau\u010dit se n\u011bco o tabulkov\u00fdch vzorc\u00edch.&nbsp;<\/p>\n\n\n\n<p>\u010c\u00edm \u010dast\u011bji je budete pou\u017e\u00edvat, t\u00edm l\u00e9pe se v nich budete orientovat, a kdykoli si nebudete v\u011bd\u011bt rady s t\u00edm, jak\u00fd \u0159et\u011bzec vzorc\u016f pou\u017e\u00edt, sta\u010d\u00ed se obr\u00e1tit na Nedetekovatelnou um\u011blou inteligenci. <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">AI Chat<\/a>, a pom\u016f\u017ee v\u00e1m rozhodnout, jak\u00fd p\u0159\u00edkaz bude pro po\u017eadovan\u00fd v\u00fdpo\u010det nejvhodn\u011bj\u0161\u00ed.&nbsp;<\/p>\n\n\n\n<p>Sv\u016fj vzorec m\u016f\u017eete tak\u00e9 p\u0159ekontrolovat tak, \u017ee ho projdete p\u0159es AI Chat, abyste si ov\u011b\u0159ili, \u017ee ned\u011bl\u00e1te \u017e\u00e1dn\u00e9 chyby.<\/p>\n\n\n\n<p>Vyzkou\u0161ejte <a href=\"https:\/\/undetectable.ai\/\" target=\"_blank\" rel=\"noreferrer noopener\">Nezjistiteln\u00e1 AI<\/a> dnes!<\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":15,"featured_media":20575,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-20569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-news"],"_links":{"self":[{"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/posts\/20569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/comments?post=20569"}],"version-history":[{"count":5,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/posts\/20569\/revisions"}],"predecessor-version":[{"id":20585,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/posts\/20569\/revisions\/20585"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/media\/20575"}],"wp:attachment":[{"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/media?parent=20569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/categories?post=20569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/cs\/wp-json\/wp\/v2\/tags?post=20569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}