Y\u00f6ntem 1: E\u015fle\u015fen ilk sat\u0131rdaki D\u00dc\u015eEYARA ve SUM de\u011ferleri<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl , A2:D11<\/strong> aral\u0131\u011f\u0131n\u0131n ilk sat\u0131r\u0131n\u0131n 2, 3 ve 4. s\u00fctunlar\u0131ndaki de\u011ferleri toplar; burada A s\u00fctunundaki de\u011fer, A14<\/strong> h\u00fccresindeki de\u011fere e\u015fittir.<\/span><\/p>\n Y\u00f6ntem 2: E\u015fle\u015fen t\u00fcm sat\u0131rlardaki D\u00dc\u015eEYARA ve SUM de\u011ferleri<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, A s\u00fctunundaki de\u011ferin A14<\/strong> h\u00fccresindeki de\u011fere e\u015fit oldu\u011fu her sat\u0131r i\u00e7in B, C ve D s\u00fctunlar\u0131ndaki de\u011ferleri toplar.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, farkl\u0131 basketbol oyuncular\u0131n\u0131n \u00fc\u00e7 farkl\u0131 ma\u00e7ta att\u0131\u011f\u0131 say\u0131lar\u0131 g\u00f6steren Excel’deki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Chad’in \u00fc\u00e7 ma\u00e7ta kazand\u0131\u011f\u0131 puan de\u011ferlerini toplamak i\u00e7in B14<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Enter<\/strong> tu\u015funa bast\u0131\u011f\u0131m\u0131zda sonu\u00e7lar g\u00f6r\u00fcnt\u00fclenecektir:<\/span> <\/p>\n Bu form\u00fcl, Oyuncu s\u00fctununda “\u00c7ad”\u0131 bulmak i\u00e7in D\u00dc\u015eEYARA kullan\u0131r ve ard\u0131ndan \u00c7ad ile e\u015fle\u015fen ilk sat\u0131rdaki her oyun i\u00e7in puan de\u011ferlerinin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Form\u00fcl\u00fcn, “Chad” ifadesinin g\u00f6r\u00fcnd\u00fc\u011f\u00fc ilk sat\u0131rda Chad’in ald\u0131\u011f\u0131 puanlar\u0131n toplam\u0131 olan 40<\/strong> de\u011ferini d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc g\u00f6rebiliriz.<\/span><\/p>\n Oyuncu s\u00fctununun “Chad” oldu\u011fu her sat\u0131rda<\/strong> Chad’in \u00fc\u00e7 ma\u00e7ta ald\u0131\u011f\u0131 puan de\u011ferlerini toplamak i\u00e7in B14<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Enter<\/strong> tu\u015funa bast\u0131\u011f\u0131m\u0131zda sonu\u00e7lar g\u00f6r\u00fcnt\u00fclenecektir:<\/span> <\/p>\n Bu form\u00fcl, Oyuncu s\u00fctununda “\u00c7ad”\u0131 bulmak i\u00e7in D\u00dc\u015eEYARA kullan\u0131r ve ard\u0131ndan \u00c7ad’a kar\u015f\u0131l\u0131k gelen her sat\u0131rdaki<\/strong> her oyun i\u00e7in puan de\u011ferlerinin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Chad’in \u00e7\u0131kt\u0131\u011f\u0131 iki s\u0131ra boyunca toplam 102<\/strong> say\u0131 att\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcyoruz.<\/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: \u0130ki arama de\u011feriyle D\u00dc\u015eEYARA nas\u0131l yap\u0131l\u0131r<\/a> D\u00dc\u015eEYARA ger\u00e7ekle\u015ftirmek ve Excel’de birden \u00e7ok sat\u0131r eklemek i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanabilirsiniz: Y\u00f6ntem 1: E\u015fle\u015fen ilk sat\u0131rdaki D\u00dc\u015eEYARA ve SUM de\u011ferleri =SUM(VLOOKUP( A14 , $A$2:$D$11 , {2,3,4}, FALSE)) Bu \u00f6zel form\u00fcl , A2:D11 aral\u0131\u011f\u0131n\u0131n ilk sat\u0131r\u0131n\u0131n 2, 3 ve 4. s\u00fctunlar\u0131ndaki de\u011ferleri toplar; burada A s\u00fctunundaki de\u011fer, A14 h\u00fccresindeki de\u011fere e\u015fittir. Y\u00f6ntem 2: E\u015fle\u015fen t\u00fcm […]<\/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-3385","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =SUM(VLOOKUP( A14<\/span> , $A$2:$D$11<\/span> , {2,3,4}, FALSE))\n<\/strong><\/pre>\n =SUMPRODUCT(( A2:A11<\/span> = A14<\/span> )* B2:D11<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme1.jpg\")
<\/p>\n \u00d6rnek 1: D\u00dc\u015eEYARA ve e\u015fle\u015fen ilk sat\u0131rdaki de\u011ferlerin toplam\u0131<\/strong><\/h2>\n
=SUM(VLOOKUP( A14<\/span> , $A$2:$D$11<\/span> , {2,3,4}, FALSE))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme2.jpg\")
<\/p>\n \u00d6rnek 2: D\u00dc\u015eEYARA ve e\u015fle\u015fen t\u00fcm sat\u0131rlardaki de\u011ferlerin toplam\u0131<\/strong><\/h2>\n
=SUMPRODUCT(( A2:A11<\/span> = A14<\/span> )* B2:D11<\/span> )<\/strong><\/pre>\n![\"D\u00dc\u015eEYARA,](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme3.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: Birden \u00c7ok S\u00fctunu D\u00f6nd\u00fcrmek i\u00e7in D\u00dc\u015eEYARA Nas\u0131l Kullan\u0131l\u0131r<\/a>
Excel: T\u00fcm E\u015fle\u015fmeleri D\u00f6nd\u00fcrmek \u0130\u00e7in D\u00dc\u015eEYARA Nas\u0131l Kullan\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"