Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, A s\u00fctununda “De\u011fer1”, “De\u011fer2” veya “De\u011fer3″e e\u015fit olan h\u00fccrelerin say\u0131s\u0131n\u0131 sayar.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Diyelim ki Excel’de \u00e7e\u015fitli basketbol tak\u0131mlar\u0131yla ilgili bilgileri g\u00f6r\u00fcnt\u00fcleyen a\u015fa\u011f\u0131daki veri k\u00fcmesine sahibiz:<\/span> <\/p>\n A s\u00fctunundaki “Do\u011fu” veya “G\u00fcney” de\u011ferine sahip h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n A<\/strong> s\u00fctununda toplam 5<\/strong> h\u00fccrenin \u201cDo\u011fu\u201d veya \u201cG\u00fcney\u201d de\u011ferine sahip oldu\u011funu g\u00f6r\u00fcyoruz.<\/span><\/p>\n Belirli say\u0131sal de\u011ferlere sahip h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in de benzer s\u00f6z dizimini kullanabilece\u011fimizi unutmay\u0131n.<\/span><\/p>\n \u00d6rne\u011fin C<\/strong> s\u00fctunundaki 95, 99 veya 103 de\u011ferine sahip h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n C s\u00fctununda toplam 6<\/strong> h\u00fccrenin 95, 99 veya 103 de\u011ferine sahip oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n De\u011ferleri belirli say\u0131lardan b\u00fcy\u00fck veya k\u00fc\u00e7\u00fck olan h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in de benzer s\u00f6z dizimini kullanabiliriz.<\/span><\/p>\n \u00d6rne\u011fin, C<\/strong> s\u00fctunundaki de\u011feri 100’den b\u00fcy\u00fck veya<\/em> 90’dan k\u00fc\u00e7\u00fck olan h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n C s\u00fctununda toplam 7<\/strong> h\u00fccrenin 100’den b\u00fcy\u00fck veya<\/em> 90’dan k\u00fc\u00e7\u00fck de\u011fere sahip oldu\u011funu g\u00f6r\u00fcyoruz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n COUNTIF()<\/strong> i\u015flemlerinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n COUNTIF Excel’deki ba\u015fka bir sayfadan nas\u0131l kullan\u0131l\u0131r?<\/a> \u00c7o\u011fu zaman, Excel’de \u00e7e\u015fitli \u00f6l\u00e7\u00fctlerden birini kar\u015f\u0131layan bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 saymak isteyebilirsiniz. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: = SUM ( COUNTIF ( A:A , { “Value1” , “Value2”, “Value3″ } ) ) Bu \u00f6zel form\u00fcl, A s\u00fctununda “De\u011fer1”, “De\u011fer2” veya “De\u011fer3″e e\u015fit olan h\u00fccrelerin say\u0131s\u0131n\u0131 sayar. A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-2708","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =<\/span> SUM<\/span> (<\/span> COUNTIF<\/span> (<\/span> A:A<\/span> ,<\/span> {<\/span> \"Value1\"<\/span> ,<\/span> \"Value2\", \"Value3\"<\/span> }<\/span> )<\/span> )<\/span><\/span><\/strong><\/pre>\n \u00d6rnek: Excel’de COUNTIF’i VEYA ile kullanma<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-pour1.jpg\")
<\/p>\n =<\/span> SUM<\/span> (<\/span> COUNTIF<\/span> (<\/span> A:A<\/span> ,<\/span> {<\/span> \"East\"<\/span> ,<\/span> \"South\"<\/span> }<\/span> )<\/span> )<\/span><\/strong><\/span><\/pre>\n![\"Excel'de](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-pour2.jpg\")
<\/p>\n =S<\/span> UM<\/span> (<\/span> COUNTIF<\/span> (<\/span> C:C<\/span> ,<\/span> {95, 99, 103<\/span> }<\/span> )<\/span> )<\/span><\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-pour3.jpg\")
<\/p>\n =S<\/span> UM<\/span> (<\/span> COUNTIF<\/span> (<\/span> C:C<\/span> ,<\/span> {\">100\", \"<90\"<\/span> }<\/span> )<\/span> )<\/span><\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-pour4.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
COUNTIF’i Excel’de joker karakterlerle kullanma<\/a>
COUNTIFS’i Excel’de bir tarih aral\u0131\u011f\u0131yla kullanma<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"