{"id":3349,"date":"2022-08-28T15:48:50","date_gmt":"2022-08-28T13:48:50","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3349"},"modified":"2022-09-01T12:56:51","modified_gmt":"2022-09-01T10:56:51","slug":"countif-funkcija-u-excel-u","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/","title":{"rendered":"Kako se upotrebljava COUNTIF funkcija u Excel-u"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sadr\u017eaj<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#COUNTIF_funkcija_u_Excel-u\" >COUNTIF funkcija u Excel-u<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Sintaksa\" >Sintaksa<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Primeri_upotrebe\" >Primeri upotrebe<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Napomena\" >Napomena<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Excel_COUNTIF_formula\" >Excel COUNTIF formula<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Syntax\" >Syntax<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Examples_of_use\" >Examples of use<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#Remark\" >Remark<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"COUNTIF_funkcija_u_Excel-u\"><\/span><span style=\"color: #339966;\"><span style=\"vertical-align: inherit;\">COUNTIF funkcija u Excel-u <\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #339966;\"><span style=\"vertical-align: inherit;\">Po\u010dev od <a href=\"\/istorijat-dodavanja-formula-u-excelu\/\">verzije<\/a>:<strong>\u00a05.0<\/strong><\/span><\/span><\/p>\n<div class=\"field field-name-parameter-list field-type-ds field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-hidden\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"item-list\">\n<p>Jedna od veoma zna\u010dajnih verzija <a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/13\/istorijat-dodavanja-formula-u-excelu\/\">Excel-a<\/a> je verzija 5.0 iz 1994. godine kada se pored VBA, PivotTable funkcionalnosti zna\u010dajno pro\u0161irio i skup funkcija, sada nama posebno interensantna COUNTIF funkcija u Excel-u koja je detaljno obja\u0161njena na <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34\">Office<\/a> stranici za podr\u0161ku korisnicima.<\/p>\n<p><span style=\"font-size: 1.0625rem;\">U mnogim slu\u010dajevima neophodno je prebrojati vrednosti u \u0107elijama koje ispunjavaju neki logi\u010dki kriterijum.<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sintaksa\"><\/span><em>Sintaksa<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>COUNTIF(opseg, kriterijumi)<\/p>\n<ul>\n<li>Opseg (obevezan)- Grupa \u0107elija koje \u017eelimo da prebrojimo. Opseg mo\u017ee da sadr\u017ei brojeve, nizove, imenovani opseg ili reference koje sadr\u017ee brojeve. prazne i tekstualne vrednosti zanemaruju.<\/li>\n<li>Kriterijumi (obavezan)- Broj, izraz, referenca \u0107elije ili tekstualna niska koja odre\u0111uje koje \u0107elije \u0107e se prebrojavati. COUNTIF koristi samo jedan kriterijum. Ako \u017eelite da koristite vi\u0161e kriterijuma, upotrebite funkciju COUNTIFS.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Primeri_upotrebe\"><\/span>Primeri upotrebe<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>COUNTIF je ne\u0161to slo\u017eenija formula, koja mo\u017ee sadr\u017eati razne kriterijume. Konkretno u prvom primeru je to re\u010d u \u0107eliji E6, sto zna\u010di da broji \u0107elije u kojima se nalazi ta\u010dno odre\u0111ena vrednost. U ovom slu\u010daju re\u010d Verovatno se pojavljuje pet puta i rezultat je 5. Formula je: =COUNTIF($E$6:$E$20;$E$6)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3354 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp1.png\" alt=\"\" width=\"245\" height=\"487\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp1.png 245w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp1-151x300.png 151w\" sizes=\"auto, (max-width: 245px) 100vw, 245px\" \/><\/p>\n<p>Drugi primer govori koliko \u0107elija ima vrednost ve\u0107u od definisane (od broja 2). U suprotnom isto va\u017ei, ako koristimo znak manje, mo\u017eemo da vidimo koliko \u0107elija ima vrednost manju od definisane. Formula je: =COUNTIF(B1:B7;\u201d&gt;2\u2033) (rezultat je 5)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3363 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp2.png\" alt=\"\" width=\"328\" height=\"272\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp2.png 328w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp2-300x249.png 300w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/p>\n<p>Primer sli\u010dan prethodnom je tre\u0107i primer, samo \u0161to ovde mo\u017eemo izbrojati vrednost koja je ve\u0107a ili jednaka definisanoj. Kada je u pitanju manje ili jednako, procedura je ista. Formula je: Formula je: =COUNTIF(B1:B7;\u201d&gt;=2\u2033) (rezultat je 7)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3365 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp3.png\" alt=\"\" width=\"330\" height=\"278\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp3.png 330w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp3-300x253.png 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/p>\n<p>U pitanju je nesto slo\u017eenija formula koja pokazuje koliko \u0107elija ima vrednost ve\u0107u od dva, a manju od sedam. Formula je: =COUNTIF(B1:B7;\u201d&lt;7\u2033)-COUNTIF(B1:B7;\u201d&lt;2\u2033) (rezultat je 3)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3366 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp4.png\" alt=\"\" width=\"466\" height=\"277\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp4.png 466w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/CountIFp4-300x178.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><\/p>\n<p>U poslednjem primeru za funkciju Countif, pokazan je broj \u0107elija koje sadr\u017ee odre\u0111enu re\u010d. Znak zvezdice zamenjuje bilo koji drugi simbol. Zato mo\u017eemo da ga kombinujemo sa drugim re\u010dima. Na primeru na slici, mi brojimo svaku \u0107eliju koja sadr\u017ee re\u010d izve\u0161taj, bilo da je ona na po\u010detku, na kraju ili na sredini.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Napomena\"><\/span><em>Napomena<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Formula COUNTIF prima gre\u0161ku #VALUE! kada upu\u0107uje na drugi radni list, ova gre\u0161ka javlja se kada formula koja sadr\u017ei funkciju upu\u0107uje na \u0107elije ili opseg u zatvorenoj radnoj svesci, a \u0107elije se izra\u010dunavaju. Da bi ova funkcija radila, druga radna sveska mora biti otvorena.\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3349&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;4\\\/5 - (4 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Kako se upotrebljava COUNTIF funkcija u Excel-u&quot;,&quot;width&quot;:&quot;113.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 113.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4\/5 - (4 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>COUNTIF funkcija u Excel-u Po\u010dev od verzije:\u00a05.0 Jedna od veoma zna\u010dajnih verzija Excel-a je verzija 5.0 iz 1994. godine kada<\/p>\n","protected":false},"author":1,"featured_media":3352,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-3349","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>countif-funkcija-u-excel-u<\/title>\n<meta name=\"description\" content=\"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"countif-funkcija-u-excel-u\" \/>\n<meta property=\"og:description\" content=\"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-28T13:48:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-01T10:56:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png\" \/>\n\t<meta property=\"og:image:width\" content=\"272\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Kako se upotrebljava COUNTIF funkcija u Excel-u\",\"datePublished\":\"2022-08-28T13:48:50+00:00\",\"dateModified\":\"2022-09-01T10:56:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\"},\"wordCount\":916,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Countif.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\",\"name\":\"countif-funkcija-u-excel-u\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Countif.png\",\"datePublished\":\"2022-08-28T13:48:50+00:00\",\"dateModified\":\"2022-09-01T10:56:51+00:00\",\"description\":\"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Countif.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Countif.png\",\"width\":272,\"height\":200,\"caption\":\"COUNTIF funkcija u Excelu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kako se upotrebljava COUNTIF funkcija u Excel-u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"countif-funkcija-u-excel-u","description":"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.","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:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/","og_locale":"en_US","og_type":"article","og_title":"countif-funkcija-u-excel-u","og_description":"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.","og_url":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-08-28T13:48:50+00:00","article_modified_time":"2022-09-01T10:56:51+00:00","og_image":[{"width":272,"height":200,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Kako se upotrebljava COUNTIF funkcija u Excel-u","datePublished":"2022-08-28T13:48:50+00:00","dateModified":"2022-09-01T10:56:51+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/"},"wordCount":916,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png","articleSection":["Poslovni Excel"],"inLanguage":"sr-SR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/","url":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/","name":"countif-funkcija-u-excel-u","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png","datePublished":"2022-08-28T13:48:50+00:00","dateModified":"2022-09-01T10:56:51+00:00","description":"Koristimo funkciju COUNTIF, jednu od statisti\u010dkih funkcija za prebrojavanje \u0107elija koje ispunjavaju kriterijum.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/08\/Countif.png","width":272,"height":200,"caption":"COUNTIF funkcija u Excelu"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Kako se upotrebljava COUNTIF funkcija u Excel-u"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3349"}],"version-history":[{"count":11,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3349\/revisions"}],"predecessor-version":[{"id":3371,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3349\/revisions\/3371"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3352"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}