{"id":1668,"date":"2023-11-12T14:09:55","date_gmt":"2023-11-12T14:09:55","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/"},"modified":"2023-12-10T06:01:39","modified_gmt":"2023-12-10T06:01:39","slug":"metin-iceren-hucreleri-say","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/","title":{"rendered":"Excel&#39;de metin i\u00e7eren h\u00fccreleri nas\u0131l sayabilirim?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-750624004\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ge\u00e7en hafta okuyucular\u0131mdan biri benden metin i\u00e7eren h\u00fccreleri saymak i\u00e7in kullanabilece\u011fi basit bir form\u00fcl istedi. Temel olarak, kullan\u0131lacak en iyi y\u00f6ntemin ne oldu\u011funu bulmaya \u00e7al\u0131\u015f\u0131yordu.<\/p><p> Ama bir saniyeli\u011fine d\u00fc\u015f\u00fcn\u00fcrseniz. Excel&#8217;de, metin de\u011ferlerinin bulundu\u011fu t\u00fcm h\u00fccreleri saymak i\u00e7in farkl\u0131 form\u00fclleriniz vard\u0131r. Ama \u00f6nemli olan hangisini kullanman\u0131z gerekti\u011fidir.<\/p><p> Bence duruma ba\u011fl\u0131. Burada anlaman\u0131z gereken \u015fey, metin i\u00e7eren h\u00fccrelerin, say\u0131lar\u0131n, bo\u015f h\u00fccrelerin veya hatalar\u0131n bulunmad\u0131\u011f\u0131 h\u00fccreler anlam\u0131na geldi\u011fidir.<\/p><p> Bug\u00fcn bu makalede, farkl\u0131 durumlarda metin i\u00e7eren h\u00fccreleri sayman\u0131n 6 farkl\u0131 yolunu payla\u015fmak istiyorum.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 1. Metin de\u011ferlerine sahip h\u00fccreyi saymak i\u00e7in joker karakterli COUNTIF<\/h2><p> Metin i\u00e7eren h\u00fccreleri sayman\u0131n en iyi form\u00fcl\u00fc, <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\" data-wpil=\"url\">joker karakterli<\/a> (* \u2013 Y\u0131ld\u0131z i\u015fareti) COUNTIF&#8217;tir. A\u015fa\u011f\u0131daki veri tablosunda tek bir s\u00fctunda isim ve cep telefonu numaralar\u0131ndan olu\u015fan bir listeniz var. Ve bu listeden adlar\u0131 (metin) olan h\u00fccrelerin say\u0131s\u0131n\u0131 sayman\u0131z gerekir. Form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIF(A2:A20,\"*\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" class=\"wp-image-12935\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png\" sizes=\"\" srcset=\"\" alt=\"sayma-ve-astrisk-min kullanarak-metinle-h\u00fccreleri say\"><\/figure><\/div><p> Girdi\u011finizde, yaln\u0131zca metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl \u015fu \u015fekilde \u00e7al\u0131\u015f\u0131yor<\/h3><p> Burada belirli kriterlere sahip h\u00fccreleri saymak i\u00e7in COUNTIF&#8217;i kulland\u0131k ve kriterler i\u00e7in y\u0131ld\u0131z i\u015faretini kulland\u0131k. Y\u0131ld\u0131z i\u015fareti kulland\u0131\u011f\u0131n\u0131zda, mant\u0131ksal de\u011ferler, say\u0131lar (metin olarak girilmediyse) ve hatalar d\u0131\u015f\u0131nda herhangi bir say\u0131da karakter i\u00e7eren h\u00fccreleri sayar.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/fazladan-bosluklari-kaldir\/\" target=\"_blank\" rel=\"noopener noreferrer\">Yaln\u0131zca bo\u015f alan\u0131n bulundu\u011fu<\/a> h\u00fccreler varsa bu metin olarak say\u0131l\u0131r. Bunun i\u00e7in form\u00fcl\u00fcn\u00fcz\u00fc bu \u015fekilde de\u011fi\u015ftirebilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIFS(A2:A20,\"*\",A2:A20,\"&lt;&gt; \")<\/code><\/pre><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 2. SUMproduct ve ISTEXT metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in<\/h2><p> Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in SUMproduct ve ISTEXT&#8217;i birle\u015ftirerek de bir form\u00fcl olu\u015fturabilirsiniz. Ve form\u00fcl \u015f\u00f6yle olacak: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--ISTEXT(A2:A20))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-compter-les-cellules-avec-du-texte-en-utilisant-sumproduct-et-istext-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"486\" height=\"336\" data-attachment-id=\"12936\"><\/p><p> Girdi\u011finizde, metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl \u015fu \u015fekilde \u00e7al\u0131\u015f\u0131yor<\/h3><p> Bu form\u00fcl\u00fc anlamak i\u00e7in onu \u00fc\u00e7 farkl\u0131 par\u00e7aya b\u00f6lmeniz gerekir.<\/p><p> <strong>\u00d6ncelikle<\/strong> bir h\u00fccrenin metin i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek i\u00e7in ISTEXT&#8217;i kulland\u0131n\u0131z. Burada ISTEXT, metin i\u00e7eren h\u00fccreler i\u00e7in DO\u011eRU&#8217;ya ve di\u011fer t\u00fcm h\u00fccreler i\u00e7in YANLI\u015e&#8217;a sahip oldu\u011funuz t\u00fcm h\u00fccreler i\u00e7in <strong>bir dizi d\u00f6nd\u00fcr\u00fcr<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-compter-les-cellules-avec-du-texte-en-utilisant-sumproduct-et-istext-true-false-array-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> <strong>\u0130kinci olarak,<\/strong> DO\u011eRU\/YANLI\u015e dizisini 1\/0&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00e7ift eksi i\u015fareti eklersiniz. Art\u0131k metin i\u00e7eren t\u00fcm h\u00fccreler i\u00e7in 1 ve di\u011ferleri i\u00e7in 0&#8217;\u0131n\u0131z var. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-de-comptage-avec-du-texte-en-utilisant-sumproduct-et-istext-un-tableau-zero-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> <strong>\u00dc\u00e7\u00fcnc\u00fcs\u00fc,<\/strong> bu diziyi toplamak i\u00e7in SUMproduct&#8217;\u0131 kulland\u0131n\u0131z. Ve bu toplam, metni i\u00e7eren h\u00fccrelerin say\u0131s\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-compter-les-cellules-avec-du-texte-en-utilisant-sumproduct-et-istext-un-zero-somme-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> SUMproduct&#8217;\u0131 burada kullanman\u0131n avantaj\u0131, form\u00fcllerinizi tablo bi\u00e7iminde girmenize gerek olmamas\u0131d\u0131r.<\/p><h2 class=\"wp-block-heading\"> 3. Belirli bir metne sahip h\u00fccreleri sayma form\u00fcl\u00fc<\/h2><p> \u015eimdi biraz daha derine inelim. Belirli bir metnin bulundu\u011fu h\u00fccreleri sayman\u0131z gerekti\u011fini varsayal\u0131m. \u0130\u015fte bir \u00f6rnek. A\u015fa\u011f\u0131daki veri tablosunda &#8220;John&#8221; yazan h\u00fccreyi sayman\u0131z gerekiyor. Ve bunun i\u00e7in form\u00fcl \u015fu \u015fekilde olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIF(A2:A20,\"John\")<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-de-comptage-avec-texte-specifique-avec-countif-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"313\" data-attachment-id=\"12940\"><\/p><p> Bu form\u00fcl, belirtti\u011finiz metnin bulundu\u011fu h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h2 class=\"wp-block-heading\"> 4. K\u0131smi metin i\u00e7eren h\u00fccreler<\/h2><p> Bu bazen k\u0131smi metni e\u015fle\u015ftirerek h\u00fccreleri sayman\u0131z gerekti\u011finde meydana gelir. COUNTIF ve joker karakterler bu konuda size yard\u0131mc\u0131 olabilir.<\/p><p> \u00dcr\u00fcn ad\u0131 ve fatura numaralar\u0131n\u0131n bir arada bulundu\u011fu a\u015fa\u011f\u0131daki tabloya bak\u0131n. Ve oradan \u201c\u00dcr\u00fcn-A\u201d i\u00e7eren h\u00fccre say\u0131s\u0131n\u0131 sayman\u0131z gerekiyor. A\u015fa\u011f\u0131daki form\u00fcl\u00fc kullan\u0131n: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIF(A2:A20,\"Product-A*\")<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cellules-de-comptage-avec-texte-specifique-partiel-specifique-countif-asterisque-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"462\" height=\"312\" data-attachment-id=\"12941\"><\/p><p> Bu form\u00fcl, \u201c\u00dcr\u00fcn-A\u201dya sahip oldu\u011funuz h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h2 class=\"wp-block-heading\"> 5. B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 metin<\/h2><p> \u015eimdi burada farkl\u0131 bir durum var. Belirli bir metni i\u00e7eren h\u00fccreleri sayman\u0131z gerekir ve bu, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 bir say\u0131 olmal\u0131d\u0131r.<\/p><p> A\u015fa\u011f\u0131daki tabloda &#8220;JOHN&#8221; isminin oldu\u011fu h\u00fccreleri sayman\u0131z gerekiyor ancak burada ayn\u0131 ismin k\u00fc\u00e7\u00fck harflerle yaz\u0131lmas\u0131 gerekiyor ancak say\u0131n\u0131n b\u00fcy\u00fck harf olmas\u0131 gerekiyor.<\/p><p> Bunun i\u00e7in SUMproduct&#8217;\u0131 EXACT ile birle\u015ftirebilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--EXACT(\"JOHN\",A1:A20))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-cellules-de-comptage-avec-texte-min-exact-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"526\" height=\"323\" data-attachment-id=\"12942\"><\/p><p> &#8220;JOHN&#8221; harfinin bulundu\u011fu h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fcl\u00fc anlamak i\u00e7in onu \u00fc\u00e7 farkl\u0131 par\u00e7aya b\u00f6lmeniz gerekir.<\/p><p> \u0130lk olarak, t\u00fcm h\u00fccre aral\u0131\u011f\u0131n\u0131 &#8220;JOHN&#8221; metniyle kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in EXACT&#8217;\u0131 kulland\u0131n\u0131z. &#8220;JOHN&#8221; olan h\u00fccreler i\u00e7in DO\u011eRU olan, &#8220;john&#8221;, &#8220;John&#8221; ve di\u011fer t\u00fcm h\u00fccreleri yok sayan bir dizi d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-cellules-de-comptage-avec-texte-exact-vrai-faux-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> \u0130kinci olarak, bu DO\u011eRU\/YANLI\u015e dizisini 1\/0&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00e7ift eksi i\u015fareti eklersiniz. Art\u0131k &#8220;JOHN&#8221; i\u00e7eren t\u00fcm h\u00fccreler i\u00e7in di\u011ferlerinin t\u00fcm\u00fc i\u00e7in 1 ve 0&#8217;\u0131n\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-cellules-de-comptage-avec-texte-exact-un-zero-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"metin-kesin-bir-s\u0131f\u0131r-dizi-dakika ile-h\u00fccreleri say\"><\/figure><\/div><p> \u00dc\u00e7\u00fcnc\u00fcs\u00fc, bu diziyi toplamak i\u00e7in SUMproduct&#8217;\u0131 kulland\u0131n\u0131z. Bu toplam da \u201cJOHN\u201d i\u00e7eren h\u00fccrelerin say\u0131s\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-cellules-de-comptage-avec-tableau-de-somme-exacte-de-texte-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5. Metin i\u00e7eren h\u00fccreleri saymak i\u00e7in VBA<\/h2><p> Makro kodunu kullanmak b\u00fcy\u00fck bir zaman tasarrufu sa\u011flar. A\u015fa\u011f\u0131daki kodlar, se\u00e7imdeki ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131ndaki metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 sayman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> Se\u00e7im i\u00e7in:<\/h3><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub countTextSelection() Dim rng As Range Dim i As Integer For Each rng In Selection If Application.WorksheetFunction.IsText(rng) Then i = i + 1 End If Next rng MsgBox i End Sub<\/code><\/pre><h3 class=\"wp-block-heading\"> E-tablonun tamam\u0131:<\/h3><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub countTextWorksheet() Dim rng As Range Dim i As Integer For Each rng In ActiveSheet.UsedRange If Application.WorksheetFunction.IsText(rng) Then i = i + 1 End If Next rng MsgBox i End Sub<\/code><\/pre><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">Excel&#8217;de VBA nedir?<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Eminim t\u00fcm bu y\u00f6ntemler, belirli bir durumda metin i\u00e7eren h\u00fccreleri sayman\u0131z i\u00e7in yeterlidir. Size uygun oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fcz y\u00f6ntemlerden herhangi birini kullanabilirsiniz.<\/p><p> \u00c7o\u011fu durumda ilk y\u00f6ntem sorunsuz olarak uygulanabilir. Ancak daha ileri gitmek istiyorsan\u0131z ba\u015fka y\u00f6ntemler de kullanabilirsiniz. Benim i\u00e7in VBA b\u00fcy\u00fck bir zaman tasarrufu sa\u011fl\u0131yor \u00e7\u00fcnk\u00fc form\u00fclleri uygulamam gerekmiyor. \u015eimdi bana bir \u015fey s\u00f6yleme s\u0131ras\u0131 sende.<\/p><p> <strong>Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in kullanabilece\u011fimiz ba\u015fka bir y\u00f6nteminiz var m\u0131?<\/strong><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131 unutmay\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bundan keyif alacaklard\u0131r. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-cellules-avec-du-texte-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/belirli-karakterleri-say\/\">Excel&#8217;de belirli karakterleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-hucre-sayisini-say\/\">Excel&#8217;de bir aral\u0131ktaki toplam h\u00fccre say\u0131s\u0131n\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\">Excel&#8217;de benzersiz de\u011ferleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kelimeleri-say\/\">Excel&#8217;de kelimeleri sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\">Excel&#8217;de filtrelenen sat\u0131rlar\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satirlari-say-2\/\">Sat\u0131rlar\u0131 say\u0131n (t\u00fcm\u00fc, bo\u015f, bo\u015f olmayan ve rakaml\u0131)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1668","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Excel&#039;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\",\"name\":\"\u25b7 Excel&#39;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png\",\"datePublished\":\"2023-11-12T14:09:55+00:00\",\"dateModified\":\"2023-12-10T06:01:39+00:00\",\"description\":\"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de metin i\u00e7eren h\u00fccreleri nas\u0131l sayabilirim?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel&#39;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?","description":"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...","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:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?","og_description":"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...","og_url":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/","url":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/","name":"\u25b7 Excel&#39;de metin i\u00e7eren h\u00fccreler nas\u0131l say\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png","datePublished":"2023-11-12T14:09:55+00:00","dateModified":"2023-12-10T06:01:39+00:00","description":"Metin i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 saymak, farkl\u0131 durumlarda farkl\u0131 y\u00f6ntemlerle yap\u0131labilir. Ve 6 tanesini listeledim...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compter-les-cellules-avec-du-texte-en-utilisant-countif-et-astrisk-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de metin i\u00e7eren h\u00fccreleri nas\u0131l sayabilirim?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1668"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1668\/revisions"}],"predecessor-version":[{"id":2547,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1668\/revisions\/2547"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}