{"id":5431,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/prumer\/"},"modified":"2021-02-26T09:50:10","modified_gmt":"2021-02-26T09:50:10","slug":"average","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/average\/","title":{"rendered":"PR\u016eM\u011aR"},"content":{"rendered":"

Funkce AVERAGE (v \u010desk\u00e9 verzi PR\u016eM\u011aR) pat\u0159\u00ed mezi z\u00e1kladn\u00ed a nej\u010dast\u011bji pou\u017e\u00edvan\u00e9 funkce v Excelu a Google Sheets. Je ur\u010dena k v\u00fdpo\u010dtu aritmetick\u00e9ho pr\u016fm\u011bru, co\u017e je suma v\u0161ech zadan\u00fdch hodnot d\u011blen\u00e1 po\u010dtem t\u011bchto hodnot, z ur\u010dit\u00e9ho rozsahu bun\u011bk.<\/p>\n

Detailn\u00ed popis a syntaxe<\/h2>\n

Syntaxe funkce PR\u016eM\u011aR v Microsoft Excel i Google Sheets je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

=PR\u016eM\u011aR(\u010d\u00edslo1; [\u010d\u00edslo2]; \u2026)<\/code><\/pre>\n
Kde ‚\u010d\u00edslo1‘, ‚\u010d\u00edslo2‘, \u2026 jsou argumenty, kter\u00e9 mohou b\u00fdt jak jednotliv\u00e9 \u010d\u00edseln\u00e9 hodnoty, tak cel\u00e9 rozsahy bun\u011bk, jejich\u017e pr\u016fm\u011bry chceme zjistit. Funkce automaticky ignoruje v\u0161echny textov\u00e9 hodnoty nebo pr\u00e1zdn\u00e9 bu\u0148ky nach\u00e1zej\u00edc\u00ed se v rozsahu.<\/p>\n
P\u0159\u00edklad pou\u017eit\u00ed:<\/p>\n
=PR\u016eM\u011aR(A1:A10)<\/code><\/pre>\n
Tento p\u0159\u00edklad vypo\u010d\u00edt\u00e1 pr\u016fm\u011br hodnot ve v\u0161ech bu\u0148k\u00e1ch od A1 do A10.<\/p>\n
Praktick\u00e9 \u00falohy a \u0159e\u0161en\u00ed<\/h2>\n
Zde uv\u00e1d\u00edme dva praktick\u00e9 p\u0159\u00edklady, ve kter\u00fdch v\u00e1m m\u016f\u017ee funkce PR\u016eM\u011aR pomoci:<\/p>\n
\u00daloha 1: V\u00fdpo\u010det pr\u016fm\u011brn\u00e9ho m\u011bs\u00ed\u010dn\u00edho v\u00fdd\u011blku<\/h2>\n
M\u00e1te k dispozici seznam m\u011bs\u00ed\u010dn\u00edch plat\u016f zam\u011bstnanc\u016f ve firm\u011b, ulo\u017een\u00fdch v bu\u0148k\u00e1ch B2 a\u017e B21, a pot\u0159ebujete vypo\u010d\u00edtat pr\u016fm\u011brn\u00fd m\u011bs\u00ed\u010dn\u00ed v\u00fdd\u011blek.<\/p>\n
    \n
  • Do bu\u0148ky B22 zadejte formuli:<\/li>\n<\/ul>\n
    =PR\u016eM\u011aR(B2:B21)<\/code><\/pre>\n
    V\u00fdsledn\u00e1 hodnota ukazuje pr\u016fm\u011brn\u00fd m\u011bs\u00ed\u010dn\u00ed plat zam\u011bstnanc\u016f, co\u017e m\u016f\u017ee b\u00fdt pomocn\u00e9 p\u0159i anal\u00fdze rozpo\u010dt\u016f nebo rozhodov\u00e1n\u00ed o p\u0159\u00edpadn\u00fdch zm\u011bn\u00e1ch ve v\u00fdplat\u00e1ch.<\/p>\n
    \u00daloha 2: Zji\u0161\u0165ov\u00e1n\u00ed pr\u016fm\u011brn\u00e9ho v\u00fdkonu studenta<\/h2>\n
    Jako u\u010ditel chcete zjistit pr\u016fm\u011brnou zn\u00e1mku studenta v p\u0159edm\u011btu za cel\u00fd \u0161koln\u00ed rok. Zn\u00e1mky jsou zaps\u00e1ny v bu\u0148k\u00e1ch D2 do D11.<\/p>\n
      \n
    • Do bu\u0148ky D12 vlo\u017ete n\u00e1sleduj\u00edc\u00ed formuli:<\/li>\n<\/ul>\n
      =PR\u016eM\u011aR(D2:D11)<\/code><\/pre>\n
      Z\u00edskan\u00fd pr\u016fm\u011br odr\u00e1\u017e\u00ed celkov\u00fd \u0161koln\u00ed v\u00fdkon studenta v dan\u00e9m p\u0159edm\u011btu a pom\u016f\u017ee ur\u010dit, zda student konzistentn\u011b dosahuje dobr\u00fdch v\u00fdsledk\u016f nebo zda pot\u0159ebuje dal\u0161\u00ed podporu pro zlep\u0161en\u00ed.<\/p>\n
      Tyto p\u0159\u00edklady demonstruj\u00ed, jak funkce PR\u016eM\u011aR m\u016f\u017ee efektivn\u011b slou\u017eit pro r\u016fzn\u00e9 anal\u00fdzy, od podnikov\u00e9ho pl\u00e1nov\u00e1n\u00ed a\u017e po akademick\u00e9 hodnocen\u00ed, a pom\u00e1h\u00e1 snadno identifikovat tendence a pot\u0159eby na z\u00e1klad\u011b numerick\u00fdch dat.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Vr\u00e1t\u00ed pr\u016fm\u011brnou hodnotu argument\u016f<\/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-5431","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce AVERAGE (PR\u016eM\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije AVERAGE (PR\u016eM\u011aR) 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\/average\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce AVERAGE (PR\u016eM\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije AVERAGE (PR\u016eM\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/average\/\" \/>\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:10+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce AVERAGE (PR\u016eM\u011aR) 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\/average\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/average\/\",\"name\":\"Funkce AVERAGE (PR\u016eM\u011aR) 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:10+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije AVERAGE (PR\u016eM\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/average\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/average\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/average\/#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\":\"PR\u016eM\u011aR\"}]},{\"@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 AVERAGE (PR\u016eM\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije AVERAGE (PR\u016eM\u011aR) 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\/average\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce AVERAGE (PR\u016eM\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije AVERAGE (PR\u016eM\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/average\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:50:10+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce AVERAGE (PR\u016eM\u011aR) 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\/average\/","url":"https:\/\/functiontranslator.com\/cs\/average\/","name":"Funkce AVERAGE (PR\u016eM\u011aR) 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:10+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije AVERAGE (PR\u016eM\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/average\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/average\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/average\/#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":"PR\u016eM\u011aR"}]},{"@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\/5431","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=5431"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5431\/revisions"}],"predecessor-version":[{"id":30570,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5431\/revisions\/30570"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}