{"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":"[:sr]Kako se upotrebljava COUNTIF funkcija u Excel-u[:en]How to use the COUNTIF function in Excel[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 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\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/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[:sr]\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.[:en]\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\" 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;0&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}\">\n<div class=\"kksr-stars\">\n<div class=\"kksr-stars-inactive\">\n<div class=\"kksr-star\" data-star=\"1\">\n<div class=\"kksr-icon\">\n<h2><span class=\"ez-toc-section\" id=\"Excel_COUNTIF_formula\"><\/span><span style=\"color: #339966;\">Excel COUNTIF formula<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #339966;\">Appears from <span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/kalkulacija.com\/istorijat-dodavanja-formula-u-excelu\/\">version<\/a>:<\/span> <strong>5.0<\/strong><\/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>One of the most important versions of\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/13\/istorijat-dodavanja-formula-u-excelu\/\">Excel<\/a>\u00a0is version 5.0 from 1994, when, in addition to VBA, PivotTable functionality, the set of functions was also significantly expanded, now the COUNTIF function is particularly interesting to us, which is explained in detail on the\u00a0<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34\">Office<\/a>\u00a0page for user support.<\/p>\n<p>In many cases, it is necessary to count values \u200b\u200bin cells that meet some logical criterion.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>We use the COUNTIF function, one of the statistical functions to count the cells that meet the criteria.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Syntax\"><\/span><span id=\"Sintaksa\" class=\"ez-toc-section\"><\/span><em>Syntax<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>COUNTIF(range, criteria)<\/p>\n<ul>\n<li>Range (required) &#8211; The group of cells we want to count.\u00a0A range can contain numbers, strings, a named range, or references that contain numbers.\u00a0blank and text values \u200b\u200bare ignored.<\/li>\n<li>Criteria (required) &#8211; A number, expression, cell reference, or text string that specifies which cells to count.\u00a0COUNTIF uses only one criterion.\u00a0If you want to use more criteria, use the COUNTIFS function.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Examples_of_use\"><\/span><span id=\"Primeri_upotrebe\" class=\"ez-toc-section\"><\/span>Examples of use<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>COUNTIF is a slightly more complex formula, which can contain various criteria.\u00a0Specifically, in the first example, it is the word in cell E6, which means that it counts the cells in which the exact value is found.\u00a0In this case the word Likely appears five times and the result is 5. The formula is: =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\" sizes=\"auto, (max-width: 245px) 100vw, 245px\" 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\" alt=\"\" width=\"245\" height=\"487\" \/><\/p>\n<p>The second example tells how many cells have a value greater than the defined value (of the number 2).\u00a0Otherwise, the same applies, if we use the less than sign, we can see how many cells have a value less than the defined one.\u00a0The formula is: =COUNTIF(B1:B7;\u201d&gt;2\u2033) (result is 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\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" 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\" alt=\"\" width=\"328\" height=\"272\" \/><\/p>\n<p>An example similar to the previous one is the third example, only here we can count a value that is greater than or equal to the defined one.\u00a0When it comes to less than or equal to, the procedure is the same.\u00a0The formula is: The formula is: =COUNTIF(B1:B7;\u201d&gt;=2\u2033) (result is 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\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" 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\" alt=\"\" width=\"330\" height=\"278\" \/><\/p>\n<p>It is a somewhat more complex formula that shows how many cells have a value greater than two and less than seven.\u00a0The formula is: =COUNTIF(B1:B7;\u201d&lt;7\u2033)-COUNTIF(B1:B7;\u201d&lt;2\u2033) (result is 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\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" 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\" alt=\"\" width=\"466\" height=\"277\" \/><\/p>\n<p>In the last example for the Countif function, the number of cells that contain a specific word is shown.\u00a0The asterisk replaces any other symbol.\u00a0That&#8217;s why we can combine it with other words.\u00a0In the example in the picture, we count every cell that contains the word report, whether it is at the beginning, end, or middle.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Remark\"><\/span><span id=\"Napomena\" class=\"ez-toc-section\"><\/span><em>Remark<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The COUNTIF formula receives an error #VALUE! when referencing another worksheet This error occurs when a formula containing a function references cells or a range in a closed workbook, and the cells are being calculated. Another workbook must be open for this feature to work.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n[:]\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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;4\\\/5 - (4 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Kako se upotrebljava COUNTIF funkcija u Excel-u[:en]How to use the COUNTIF function in Excel[:]&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>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] 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<\/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 v28.8 - 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\":\"[:sr]Kako se upotrebljava COUNTIF funkcija u Excel-u[:en]How to use the COUNTIF function in Excel[:]\",\"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\":\"en-US\",\"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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/countif-funkcija-u-excel-u\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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":"[:sr]Kako se upotrebljava COUNTIF funkcija u Excel-u[:en]How to use the COUNTIF function in Excel[:]","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":"en-US","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":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/countif-funkcija-u-excel-u\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@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}]}}