\u00c7o\u011fu zaman, yaln\u0131zca kar\u015f\u0131l\u0131k gelen s\u00fctundaki bir h\u00fccrenin belirli bir gereksinimi kar\u015f\u0131lamas\u0131 durumunda<\/em> bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in COUNTA<\/strong> i\u015flevini bir IF<\/strong> i\u015fleviyle birlikte kullanmak isteyebilirsiniz.<\/span><\/p>\n Neyse ki bunu ba\u015farmak i\u00e7in COUNTIFS<\/strong> i\u015flevini kullanabilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n Farkl\u0131 basketbol oyuncular\u0131n\u0131n att\u0131\u011f\u0131 say\u0131lar\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki, Pozisyon<\/strong> s\u00fctununda “Guard” yazan oyuncular\u0131n say\u0131s\u0131n\u0131, ancak Puan<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen h\u00fccre bo\u015f olmad\u0131\u011f\u0131 s\u00fcrece saymak istiyoruz.<\/span><\/p>\n Bu say\u0131y\u0131 hesaplamak 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 Form\u00fcl 5<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Bu bize, Pozisyon<\/strong> s\u00fctununda “Guard” de\u011ferine sahip 5<\/strong> oyuncunun bulundu\u011funu ve Puan<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen de\u011ferin bo\u015f olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Bu kriterleri kar\u015f\u0131layan be\u015f oyuncuyu manuel olarak belirleyerek bunun do\u011fru oldu\u011funu do\u011frulayabiliriz:<\/span> <\/p>\n Vurgulanan sat\u0131rlar\u0131n her biri, Pozisyon<\/strong> s\u00fctununda “Guard” de\u011ferine sahip bir oyuncu i\u00e7erir; burada Puan<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011fer bo\u015f de\u011fildir.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r?<\/a> Bir aral\u0131ktaki bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in Excel’deki COUNTA i\u015flevini kullanabilirsiniz. \u00c7o\u011fu zaman, yaln\u0131zca kar\u015f\u0131l\u0131k gelen s\u00fctundaki bir h\u00fccrenin belirli bir gereksinimi kar\u015f\u0131lamas\u0131 durumunda bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in COUNTA i\u015flevini bir IF i\u015fleviyle birlikte kullanmak isteyebilirsiniz. Neyse ki bunu ba\u015farmak i\u00e7in COUNTIFS i\u015flevini kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. […]<\/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-4903","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: Excel’de COUNTA’y\u0131 IF ile kullanma<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cai1.png\")
<\/p>\n =COUNTIFS( A2:A16<\/span> , \"Guard\", B2:B16<\/span> , \"<>\"&\"\")<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cai2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cai3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de kopyalar nas\u0131l say\u0131l\u0131r<\/a>
Excel’de gruba g\u00f6re sayma<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"