{"id":1605,"date":"2023-02-04T17:28:23","date_gmt":"2023-02-04T14:28:23","guid":{"rendered":"https:\/\/www.bilgiislem.net.tr\/?p=1605"},"modified":"2023-02-04T17:34:44","modified_gmt":"2023-02-04T14:34:44","slug":"belirli-kelimeyi-bulunduran-hucrelerin-adedi","status":"publish","type":"post","link":"https:\/\/www.bilgiislem.net.tr\/?p=1605","title":{"rendered":"Belirli Kelimeyi Bulunduran H\u00fccrelerin Adedi"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-505 aligncenter\" src=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png\" alt=\"\" width=\"1000\" height=\"47\" srcset=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png 1000w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-300x14.png 300w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-768x36.png 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p>\u00d6rne\u011fin, tablomuzun ba\u015fl\u0131\u011f\u0131n\u0131 \u015fu yapt\u0131k &#8220;STOK DURUMU&#8221;. Ve, ba\u015fl\u0131\u011f\u0131n alt\u0131na 2 de\u011ferde, \u00fcr\u00fcnleri yazd\u0131k, &#8220;VAR&#8221; veya &#8220;YOK&#8221; olarak.<\/p>\n<p>Bu durumda, &#8220;VAR&#8221; yazan h\u00fccrelerin adedini (bir sat\u0131rdaki ka\u00e7 h\u00fccrede &#8220;VAR&#8221; yaz\u0131yor) \u00f6\u011frenmek i\u00e7in \u015fu form\u00fcl\u00fc kullan\u0131yoruz:<\/p>\n<p><span style=\"color: #ff0000;\">T\u00fcrk\u00e7e (Turkish): <strong>E\u011eERSAY<\/strong><\/span><\/p>\n<p><span style=\"color: #0000ff;\">English (\u0130ngilizce): <strong>COUNTIF<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-505 aligncenter\" src=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png\" alt=\"\" width=\"1000\" height=\"47\" srcset=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png 1000w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-300x14.png 300w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-768x36.png 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p>Bu sayfay\u0131 haz\u0131rlarken g\u00f6zatt\u0131m:<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ways-to-count-cells-in-a-range-of-data-3e0b3b7a-e0e4-478a-a940-889400120072\" target=\"_blank\" rel=\"noopener\">microsoft.com<\/a> | Ways to count cells in a range of data<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/tr-tr\/office\/etopla-i%C5%9Flevi-169b8c99-c05c-4483-a712-1697a653039b\" target=\"_blank\" rel=\"noopener\">microsoft.com<\/a> | ETOPLA i\u015flevi<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706\" target=\"_blank\" rel=\"noopener\">microsoft.com<\/a>\u00a0| Use AutoSum to sum numbers<\/li>\n<li><a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/excel-sum-formula-total-column-rows-cells\/\" target=\"_blank\" rel=\"noopener\">ablebits.com<\/a> | Excel SUM formula to total a column, rows or only visible cells<\/li>\n<\/ul>\n<p>Di\u011fer ili\u015fikli form\u00fcller:<\/p>\n<ul>\n<li>COUNTA: To count cells that are not empty (bo\u015f olmayan ka\u00e7 h\u00fccre\/kutucuk var, onu s\u00f6yler)<\/li>\n<li>COUNT: To count cells that contain numbers. (say\u0131 bulunduran h\u00fccrelerin\/kutucuklar\u0131n adedini s\u00f6yler)<\/li>\n<li>COUNTBLANK: To count cells that are blank. (bo\u015f olan h\u00fccrelerin\/kutucuklar\u0131n adedini s\u00f6yler)<\/li>\n<li>COUNTIF: To count cells that meets a specified criteria. (belirli bir kriteri sa\u011flayan, yani \u00f6rne\u011fin &#8220;\u0130\u00c7ER\u0130S\u0130NDE VAR YAZAN KA\u00c7 H\u00dcCRE VAR&#8221; gibi bir kriteri sa\u011flayan h\u00fccrelerin adedini s\u00f6yler)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-505 aligncenter\" src=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png\" alt=\"\" width=\"1000\" height=\"47\" srcset=\"https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001.png 1000w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-300x14.png 300w, https:\/\/www.bilgiislem.net.tr\/wp-content\/uploads\/2022\/08\/sayfa-ayirici-sus-cizgisi_bilgiislem-001-768x36.png 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kutucuklara &#8220;VAR&#8221; veya &#8220;YOK&#8221; yazd\u0131ysak, i\u00e7erisinde &#8220;VAR&#8221; yazan ka\u00e7 kutucuk var, bunu nas\u0131l hesapl\u0131yoruz? Cevab\u0131 yaz\u0131m\u0131zda.<\/p>\n","protected":false},"author":1,"featured_media":1457,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"no_sidebar_full_width","colormag_page_sidebar_layout":"no_sidebar","footnotes":""},"categories":[575],"tags":[580,578,579,577,576],"class_list":["post-1605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-count-number-of-cells-excel-text","tag-excelde-hucrelerin-toplami","tag-number-of-cells-excel","tag-sum-of-cells-in-excel","tag-sum-of-filtered-cells-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/posts\/1605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1605"}],"version-history":[{"count":6,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/posts\/1605\/revisions"}],"predecessor-version":[{"id":1611,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/posts\/1605\/revisions\/1611"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=\/wp\/v2\/media\/1457"}],"wp:attachment":[{"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bilgiislem.net.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}