A\u015fa\u011f\u0131daki \u00f6rnekler, bu i\u015flevlerin Excel’deki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Hadi gidelim!<\/span><\/p>\n Tak\u0131m<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin “Mavs”e e\u015fit oldu\u011fu Oyuncu<\/strong> s\u00fctunundaki h\u00fccre say\u0131s\u0131n\u0131 saymak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/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 Sonu\u00e7tan, Oyuncu<\/strong> s\u00fctununda 4<\/strong> h\u00fccrenin bulundu\u011funu g\u00f6rebiliriz; burada Tak\u0131m<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccre Mavs’tir.<\/span><\/p>\n Tak\u0131m<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin “Mavs”e e\u015fit oldu\u011fu ve<\/em> Puanlar<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin 20’den b\u00fcy\u00fck oldu\u011fu Oyuncu<\/strong> s\u00fctunundaki h\u00fccre say\u0131s\u0131n\u0131 saymak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/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 Sonu\u00e7tan, Oyuncu<\/strong> s\u00fctununda, Tak\u0131m<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin Mavs oldu\u011fu ve<\/em> Puanlar<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin 20’den b\u00fcy\u00fck oldu\u011fu 2<\/strong> h\u00fccre oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n Not<\/strong> : Bu \u00f6rnekte, iki s\u00fctunun belirli kriterleri kar\u015f\u0131lay\u0131p kar\u015f\u0131lamad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in COUNTIFS<\/strong> i\u015flevini kulland\u0131k, ancak istedi\u011finiz kadar s\u00fctunun belirli kriterleri kar\u015f\u0131lay\u0131p kar\u015f\u0131lamad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in COUNTIFS<\/strong> i\u015flevini kullanabilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: Birden fazla aral\u0131kla COUNTIF kullan\u0131n<\/a> Ba\u015fka bir s\u00fctundaki de\u011ferin belirli kriterleri kar\u015f\u0131lad\u0131\u011f\u0131 bir s\u00fctundaki de\u011ferlerin say\u0131s\u0131n\u0131 saymak i\u00e7in Excel’deki COUNTIF ve COUNTIFS i\u015flevlerini kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekler, bu i\u015flevlerin Excel’deki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir: Hadi gidelim! \u00d6rnek 1: Ba\u015fka bir s\u00fctun \u00f6l\u00e7\u00fctleri kar\u015f\u0131l\u0131yorsa bir s\u00fctunu saymak i\u00e7in E\u011eERSAY komutunu kullan\u0131n Tak\u0131m s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin “Mavs”e e\u015fit oldu\u011fu […]<\/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-4801","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sia1.png\")
<\/p>\n \u00d6rnek 1: Ba\u015fka bir s\u00fctun \u00f6l\u00e7\u00fctleri kar\u015f\u0131l\u0131yorsa bir s\u00fctunu saymak i\u00e7in E\u011eERSAY komutunu kullan\u0131n<\/strong><\/span><\/h2>\n
=COUNTIF( A2:A11<\/span> , F1<\/span> )<\/strong><\/pre>\n![\"Ba\u015fka](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sia2.png\")
<\/p>\n \u00d6rnek 2: Birden fazla s\u00fctun \u00f6l\u00e7\u00fctleri kar\u015f\u0131l\u0131yorsa bir s\u00fctunu saymak i\u00e7in COUNTIFS kullan\u0131n<\/strong><\/span><\/h2>\n
=COUNTIFS( A2:A11<\/span> , F1<\/span> , C2:C11<\/span> , \">\"& F2<\/span> )<\/strong><\/pre>\n![\"Birden](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifa3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: COUNTIF’i ayn\u0131 s\u00fctunda birden \u00e7ok \u00f6l\u00e7\u00fctle kullan\u0131n<\/a>
Excel: COUNTIF belirli bir say\u0131dan b\u00fcy\u00fck ancak k\u00fc\u00e7\u00fck<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"