{"id":5433,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/averageif\/"},"modified":"2021-02-26T09:50:13","modified_gmt":"2021-02-26T09:50:13","slug":"averageif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/averageif\/","title":{"rendered":"AVERAGEIF"},"content":{"rendered":"

\u00davod do anal\u00fdzy podm\u00edn\u011bn\u00fdch pr\u016fm\u011br\u016f<\/h2>\n

Funkce pro v\u00fdpo\u010det pr\u016fm\u011bru za ur\u010dit\u00fdch podm\u00ednek je ve sv\u011bt\u011b tabulkov\u00fdch editor\u016f jako MS Excel a Google Tabulky velmi u\u017eite\u010dn\u00fd n\u00e1stroj. Tato funkce umo\u017e\u0148uje u\u017eivatel\u016fm vypo\u010d\u00edtat pr\u016fm\u011br hodnot, kter\u00e9 spl\u0148uj\u00ed konkr\u00e9tn\u00ed krit\u00e9ria. M\u016f\u017ee b\u00fdt velmi u\u017eite\u010dn\u00e1 nap\u0159\u00edklad p\u0159i anal\u00fdze dat, kdy pot\u0159ebujeme zohlednit pouze ur\u010ditou subsetu dat odpov\u00eddaj\u00edc\u00ed dan\u00fdm kriteri\u00edm.<\/p>\n

Syntax a pou\u017eit\u00ed t\u00e9to funkce<\/h2>\n

Syntaxe funkce se m\u00edrn\u011b li\u0161\u00ed mezi MS Excel a Google Tabulkami, ale z\u00e1kladn\u00ed principy jsou podobn\u00e9. Zde je obecn\u00fd p\u0159ehled syntaxe:<\/p>\n

  =FUNKCE(pr\u016fm\u011brovan\u00fd_obor; krit\u00e9ria; [pr\u016fm\u011brovan\u00fd_obor2]) <\/code> <\/pre>\n
    \n
  • pr\u016fm\u011brovan\u00fd_obor:<\/b> Odkaz na rozsah bun\u011bk, kter\u00e9 maj\u00ed b\u00fdt zahrnuty do pr\u016fm\u011brov\u00e1n\u00ed.<\/li>\n
  • krit\u00e9ria:<\/b> Podm\u00ednka ve form\u011b textu nebo \u010d\u00edsla, kter\u00e1 ur\u010duje, kter\u00e9 hodnoty z pr\u016fm\u011brovan\u00e9ho oboru maj\u00ed b\u00fdt zahrnuty do v\u00fdpo\u010dtu pr\u016fm\u011bru.<\/li>\n
  • pr\u016fm\u011brovan\u00fd_obor2 (voliteln\u011b):<\/b> Odkaz na rozsah bun\u011bk, od kter\u00e9ho se m\u00e1 pr\u016fm\u011br vypo\u010d\u00edtat, pokud se li\u0161\u00ed od pr\u016fm\u011brovan\u00e9ho_oboru, kde jsou definov\u00e1na krit\u00e9ria.<\/li>\n<\/ul>\n
    P\u0159\u00edklady praktick\u00e9ho vyu\u017eit\u00ed<\/h2>\n
    Analyzov\u00e1n\u00ed v\u00fdsledk\u016f zkou\u0161ek<\/h3>\n
    U\u010ditel chce zjistit pr\u016fm\u011brnou zn\u00e1mku student\u016f, kte\u0159\u00ed z\u00edskali v\u00edce ne\u017e 60 bod\u016f z testu. V Excelu nebo Google Tabulk\u00e1ch by mohl pou\u017e\u00edt n\u00e1sleduj\u00edc\u00ed formuli:<\/p>\n
      =FUNKCE(Zn\u00e1mky; \">60\") <\/code> <\/pre>\n
    V tomto p\u0159\u00edpad\u011b „Zn\u00e1mky“ je rozsah bun\u011bk obsahuj\u00edc\u00edch sk\u00f3re student\u016f. Formula vypo\u010dte pr\u016fm\u011brnou zn\u00e1mku pouze pro studenty, jejich\u017e sk\u00f3re p\u0159esahuje 60 bod\u016f.<\/p>\n
    Anal\u00fdza prodejn\u00edch dat<\/h3>\n
    Firma by mohla cht\u00edt analyzovat pr\u016fm\u011brn\u00fd prodej produkt\u016f, kter\u00e9 p\u0159ekro\u010dily prodejn\u00ed c\u00edl 100 kus\u016f. MS Excel a Google Tabulky nab\u00edzej\u00ed jednoduch\u00fd zp\u016fsob, jak toho dos\u00e1hnout:<\/p>\n
      =FUNKCE(Prodeje; \">100\"; Cena) <\/code> <\/pre>\n
    V tomto p\u0159\u00edkladu „Prodeje“ je oblast, kde jsou uvedeny kusy prodan\u00e9ho zbo\u017e\u00ed a „Cena“ je oblast, kde jsou uvedeny jejich ceny. Tento vzorec poskytne pr\u016fm\u011brnou cenu pouze pro produkty, kter\u00e9 se prodaly v po\u010dtu v\u011bt\u0161\u00edm ne\u017e 100 kus\u016f.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed pr\u016fm\u011brnou hodnotu (aritmetick\u00fd pr\u016fm\u011br) v\u0161ech bun\u011bk v oblasti, kter\u00e9 vyhovuj\u00ed p\u0159\u00edslu\u0161n\u00e9 podm\u00ednce<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5433","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/cs\/averageif\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/averageif\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:50:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/averageif\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/averageif\/\",\"name\":\"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:50:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/averageif\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/averageif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/averageif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/statisticke\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AVERAGEIF\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/cs\/averageif\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/averageif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:50:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/averageif\/","url":"https:\/\/functiontranslator.com\/cs\/averageif\/","name":"Funkce AVERAGEIF v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:50:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije AVERAGEIF u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/averageif\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/averageif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/averageif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Statistick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/statisticke\/"},{"@type":"ListItem","position":3,"name":"AVERAGEIF"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5433"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5433\/revisions"}],"predecessor-version":[{"id":30572,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5433\/revisions\/30572"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}