{"id":1467,"date":"2019-12-09T10:36:42","date_gmt":"2019-12-09T10:36:42","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=1467"},"modified":"2021-04-09T13:17:30","modified_gmt":"2021-04-09T13:17:30","slug":"cum-se-utilizeaza-functia-countif-tipstricks","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/cum-se-utilizeaza-functia-countif-tipstricks\/","title":{"rendered":"Cum se utilizeaza functia countif &#8211; Tips&#038;Tricks"},"content":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text]<\/p>\n<h3 style=\"text-align: left;\"><strong>COUNTIF<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Windows shortcut: n\/a<\/h4>\n<p style=\"text-align: left;\"><a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">COUNTIF<\/a> este o functie cu ajutorul careia numaram celulele in functie de o conditie indeplinita.<\/p>\n<h4 style=\"text-align: left;\">Structura functiei<\/h4>\n<p style=\"text-align: left;\">COUNTIF (range,criteria)<\/p>\n<p style=\"text-align: left;\">Range: Selectia de celule dorite pentru evaluare<\/p>\n<p style=\"text-align: left;\">Criteria: Conditia evaluata<\/p>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;1615&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221; qode_css_animation=&#8221;&#8221;][vc_column_text]<\/p>\n<p style=\"text-align: left;\">Observatie: Functia COUNTIF functioneaza pentru date de tip<\/p>\n<p>NUMBER, TEXT si DATA<\/p>\n<h5><\/h5>\n<h5 style=\"text-align: left;\">&#8222;Learn today for tomorrow!&#8221;<\/h5>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;3\/4&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-3 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-exemplul-1\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tExemplul 1\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-exemplul-2\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tExemplul 2\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-exemplul-3\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tExemplul 3\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-1-990\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<b>Exemplu 1<\/b>: Incercam sa aplicam functia COUNTIF asupra urmatoarea baza de date formata din cifre si incercam sa efectuam diferite operatii de numarare aplicand diferite conditii.<br \/>\n<img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-1617 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/21mod.jpg\" alt=\"\" width=\"700\" height=\"280\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/21mod.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/12\/21mod-300x120.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-2-496\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<b>Exemplu 2<\/b>: Incercam sa aplicam functia COUNTIF asupra urmatoarea baza de date formatata tip TEXT si incercam sa efectuam operatii de numarare aplicand diferite conditii.<\/p>\n<p style=\"text-align: left;\"><img decoding=\"async\" class=\"size-full wp-image-1034 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/3mod.jpg\" alt=\"\" width=\"700\" height=\"280\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/3mod.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/3mod-300x120.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><b><\/b><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-3-807\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<b>Exemplu 3<\/b>: Incercam sa aplicam functia COUNTIF asupra urmatoarea baza de date formatata tip DATA si incercam sa efectuam operatii de numarare aplicand diferite conditii.<\/p>\n<p style=\"text-align: left;\"><img decoding=\"async\" class=\"size-full wp-image-1035 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/4mod.jpg\" alt=\"\" width=\"700\" height=\"280\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/4mod.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2019\/11\/4mod-300x120.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>[\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !<\/p>\n<p>important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text] COUNTIF Windows shortcut: n\/a COUNTIF este o functie cu ajutorul careia numaram celulele in functie de o conditie indeplinita. Structura functiei COUNTIF (range,criteria) Range: Selectia de celule dorite pentru evaluare Criteria: Conditia evaluata&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1467"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=1467"}],"version-history":[{"count":2,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1467\/revisions"}],"predecessor-version":[{"id":2950,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1467\/revisions\/2950"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1467"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}