{"id":1651,"date":"2023-11-13T17:56:54","date_gmt":"2023-11-13T17:56:54","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/"},"modified":"2023-12-10T06:01:33","modified_gmt":"2023-12-10T06:01:33","slug":"kosullu-siralama-toplami-carpim-siralamasi-eger","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/","title":{"rendered":"Excel&#39;de ko\u015fullu s\u0131ralama nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3868307745\"><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>\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Excel&#8217;de neden ko\u015fullu s\u0131ralama i\u00e7in bir i\u015flevin olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz.<\/p><p> Evet kimse yok. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu at\u0131\u015ft\u0131rmal\u0131k i\u00e7in her zaman sumproduct kullan\u0131n\"><\/figure><\/div><p> \u015eimdi \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcn, de\u011ferleri belirli kriterlere g\u00f6re s\u0131ralaman\u0131z gereken bir durumla hi\u00e7 kar\u015f\u0131la\u015ft\u0131n\u0131z m\u0131? Cevab\u0131n\u0131z evet ise, Excel&#8217;de RANKIF i\u015flevi olmad\u0131\u011f\u0131n\u0131 bildi\u011finiz i\u00e7in bu sorunu nas\u0131l \u00e7\u00f6zersiniz?<\/p><p> Emin de\u011fil?<\/p><p> Size bir \u015fey s\u00f6yleyeyim, belirli bir kritere veya kategori s\u0131ralamas\u0131na g\u00f6re ko\u015fullu bir s\u0131ralama olu\u015fturmak istedi\u011finizde en iyi yol SUMPROD&#8217;u kullanmakt\u0131r. Evet do\u011fru anlad\u0131n\u0131z SUMproduct. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/a-chaque-fois-utiliser-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu at\u0131\u015ft\u0131rmal\u0131k i\u00e7in her zaman sumproduct kullan\u0131n\"><\/figure><\/div><p> Birka\u00e7 y\u0131ld\u0131r bu fonksiyona a\u015f\u0131\u011f\u0131m ve bug\u00fcn bu yaz\u0131da size SUMproduct kullanarak bir ko\u015fulla de\u011ferleri s\u0131ralaman\u0131n basit bir yolunu g\u00f6sterece\u011fim. Ve sizi ba\u015flang\u0131\u00e7 d\u00fczeyindeki bir Excel kullan\u0131c\u0131s\u0131ndan ileri d\u00fczey bir Excel kullan\u0131c\u0131s\u0131na ta\u015f\u0131yabilecek bir tekniktir.<\/p><p> <em><a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urun-2\/\">SOMMEPROD hakk\u0131nda daha fazla bilgi edinmek ister misiniz<\/a> ?<\/em><\/p><p> Ba\u015flayal\u0131m.<\/p><p> Bu \u00f6rnekte farkl\u0131 konulardaki puanlar\u0131yla birlikte \u00f6\u011frencilerin bir listesi var. Devam etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/exemples-de-rangs-conditionnels-de-donnees-avec-sumproduct.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirebilirsiniz<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-a-utiliser-pour-creer-le-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu s\u0131ralama i\u00e7in sumproduct varsa s\u0131ralama olu\u015fturmak i\u00e7in kullan\u0131lacak veri tablosu\"><\/figure><\/div><p> Burada amac\u0131m\u0131z her dersteki t\u00fcm \u00f6\u011frencileri s\u0131ralamakt\u0131r. Bu, finans, operasyon vb. her derste notlar\u0131na g\u00f6re ilk \u00f6\u011frenciden son \u00f6\u011frenciye kadar s\u0131ralama yap\u0131lmas\u0131 anlam\u0131na gelir.<\/p><h2 id=\"h-conditional-formula-to-use-it-as-rankif\" class=\"wp-block-heading\"> RANKIF olarak kullan\u0131lacak ko\u015fullu form\u00fcl<\/h2><ol><li> \u00d6ncelikle tablonun sonuna yeni bir s\u00fctun ekleyin ve ona \u201cKonu Bilge S\u0131ralamas\u0131\u201d ad\u0131n\u0131 verin. <br><img decoding=\"async\" title=\"ko\u015fullu-s\u0131ralama-min i\u00e7in-toplam\u00fcr\u00fcnle-e\u011fer-s\u0131ralama-olu\u015fturmak i\u00e7in-veri-tablosuna-yeni-s\u00fctun ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-une-nouvelle-colonne-a-la-table-de-donnees-pour-creer-un-classement-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"add new column to data table to create rank if with sumproduct for conditional ranking\"><\/li><li> D4 h\u00fccresine \u015fu form\u00fcl\u00fc girin: =TOPLA\u00c7ARP((\u2013(C2=$C$2:$C$121))(\u2013(B2&lt;$B$2:$B$121)))+1 ve Enter tu\u015funa bas\u0131n. <br><img decoding=\"async\" title=\"ko\u015fullu r\u00fctbe-min i\u00e7in toplam \u00e7arp\u0131mla s\u0131ralama olu\u015fturmak \u00fczere veri tablosuna form\u00fcller ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-formules-a-la-table-de-donnees-pour-creer-un-classement-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"add formulas to data table to create rank if with sumproduct for conditional ranking\"><\/li><li> Daha sonra bu form\u00fcl\u00fc s\u00fctunun sonuna, son h\u00fccreye kadar uygulay\u0131n. <br><img decoding=\"async\" title=\"ko\u015fullu-s\u0131ralama-min i\u00e7in-toplam-ile-s\u0131ralama-olu\u015fturmak i\u00e7in-veri-tablosuna-a\u015fa\u011f\u0131-form\u00fcl\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/faites-defiler-la-formule-vers-la-table-de-donnees-pour-creer-un-classement-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"drop down formula to data table to create rank if with sumproduct for conditional ranking\"><\/li><\/ol><p> <span style=\"color: #ea493f;\"><strong>Tebrikler<\/strong><\/span> , \u00f6\u011frenciler i\u00e7in konu s\u0131ralamas\u0131 eklediniz ve birka\u00e7 saniyenizi ay\u0131rd\u0131\u011f\u0131n\u0131z\u0131 m\u0131 d\u00fc\u015f\u00fcn\u00fcyorsunuz?<\/p><p> Basit ve etkili de\u011fil mi? Ancak \u00f6nemli olan bu form\u00fcl\u00fcn nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamakt\u0131r. Ve inan\u0131n bana, bu \u00f6zellikle burada bir sihir yapt\u0131\u011f\u0131n\u0131z\u0131 \u00f6\u011frendi\u011finizde \u015fa\u015f\u0131racaks\u0131n\u0131z.<\/p><h2 id=\"h-how-this-conditional-rankif-formula-works\" class=\"wp-block-heading\"> Bu ko\u015fullu RANKIF form\u00fcl\u00fc nas\u0131l \u00e7al\u0131\u015f\u0131r?<\/h2><p> Bunu anlamak i\u00e7in bu form\u00fcl\u00fc \u00fc\u00e7 par\u00e7aya ay\u0131rmam\u0131z gerekiyor. Ve SUMproduct&#8217;un, bir form\u00fcl\u00fc dizi olarak uygulamad\u0131\u011f\u0131n\u0131zda bile dizi alabilen bir fonksiyon oldu\u011funu unutmay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/decomposer-les-formules-en-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu s\u0131ralama i\u00e7in sumproduct ile if s\u0131ralamas\u0131 olu\u015fturmak \u00fczere form\u00fclleri veri tablosuna ayr\u0131\u015ft\u0131r\u0131n\"><\/figure><\/div><h3 id=\"h-part-1-compare-names\" class=\"wp-block-heading\"> B\u00f6l\u00fcm 1: \u0130simleri Kar\u015f\u0131la\u015ft\u0131r\u0131n<\/h3><p> \u0130lk b\u00f6l\u00fcmde, bir konu ad\u0131n\u0131 t\u00fcm aral\u0131kla kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in <span style=\"font-family: 'Courier New', Courier, monospace;\"><code>(\u2013(C2=$C$2:$C$121))<\/code><\/span> kulland\u0131n\u0131z. Ve t\u00fcm bu de\u011ferlerin do\u011fru olaca\u011f\u0131 ve &#8220;Finans&#8221; konu ad\u0131na kar\u015f\u0131l\u0131k gelece\u011fi bir dizi d\u00f6nd\u00fcrecektir.<\/p><p> Kontrol etmek i\u00e7in D4 h\u00fccresindeki form\u00fcllerinizi d\u00fczenleyin, form\u00fcl\u00fcn yaln\u0131zca ilk b\u00f6l\u00fcm\u00fcn\u00fc se\u00e7in ve F9 tu\u015funa bas\u0131n. Dizideki t\u00fcm de\u011ferleri g\u00f6sterecektir.<\/p><p> Burada D4 h\u00fccresinin konu ad\u0131yla e\u015fle\u015fen t\u00fcm de\u011ferler DO\u011eRU, geri kalanlar YANLI\u015e&#8217;t\u0131r. Yani mesele \u015fu ki, konu ad\u0131n\u0131n e\u015fle\u015fti\u011fi dizinin tamam\u0131nda bir TRUE d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifiez-la-premiere-partie-de-la-formule-dans-la-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu harmanlama i\u00e7in sumproduct ile harmanlama olu\u015fturmak \u00fczere veri tablosundaki form\u00fcl\u00fcn ilk b\u00f6l\u00fcm\u00fcn\u00fc kontrol edin\"><\/figure><\/div><p> Ve sonunda DO\u011eRU ve YANLI\u015e&#8217;\u0131 1 ve 0&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in <strong>\u00e7ift eksi i\u015faretini<\/strong> kullanman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifier-la-premiere-partie-de-la-formule-avec-le-signe-moins-dans-la-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Ko\u015fullu s\u0131ralama i\u00e7in toplam \u00fcr\u00fcn varsa, s\u0131ralamay\u0131 olu\u015fturmak i\u00e7in veri tablosunda eksi i\u015fareti bulunan form\u00fcl\u00fcn ilk b\u00f6l\u00fcm\u00fcn\u00fc kontrol edin\"><\/figure><\/div><p> Form\u00fcl\u00fcn bu b\u00f6l\u00fcm\u00fcn\u00fcn sonucu: Konunun e\u015fle\u015fti\u011fi yerde 1, konunun e\u015fle\u015fmedi\u011fi yerde 0 var.<\/p><h3 id=\"h-part-2-check-greater-than-values\" class=\"wp-block-heading\"> B\u00f6l\u00fcm 2: \u015eu de\u011ferden b\u00fcy\u00fck de\u011ferleri kontrol edin:<\/h3><p> <strong><span style=\"color: #000000;\">\u0130kinci<\/span><\/strong> b\u00f6l\u00fcmde, di\u011fer \u00f6\u011frencilerin Tameka&#8217;dan daha y\u00fcksek puanlar\u0131n\u0131 kontrol etmek i\u00e7in <span style=\"font-family: 'Courier New', Courier, monospace;\"><code>(--(B2&lt;$B$2:$B$121))<\/code><\/span> kulland\u0131n\u0131z. Ve i\u015faretlerin Tameka&#8217;dan b\u00fcy\u00fck oldu\u011fu t\u00fcm de\u011ferlerin DO\u011eRU oldu\u011fu bir dizi d\u00f6nd\u00fcr\u00fcr.<\/p><p> Kontrol etmek i\u00e7in D4 h\u00fccresindeki form\u00fcllerinizi d\u00fczenleyin, form\u00fcl\u00fcn yaln\u0131zca ikinci b\u00f6l\u00fcm\u00fcn\u00fc se\u00e7in ve F9 tu\u015funa bas\u0131n. Dizideki t\u00fcm de\u011ferleri g\u00f6sterecektir.<\/p><p> Burada \u201c24\u201dten b\u00fcy\u00fck t\u00fcm de\u011ferler DO\u011eRU, di\u011ferleri YANLI\u015et\u0131r. Yani as\u0131l nokta, puanlar\u0131n &#8220;24&#8221;ten b\u00fcy\u00fck oldu\u011fu tablonun tamam\u0131nda bir DO\u011eRU d\u00f6nd\u00fcrmesidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifiez-la-deuxieme-partie-de-la-formule-dans-la-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu r\u00fctbe minimumu i\u00e7in toplam \u00e7arp\u0131m varsa s\u0131ralamay\u0131 olu\u015fturmak i\u00e7in veri tablosundaki form\u00fcl\u00fcn ikinci b\u00f6l\u00fcm\u00fcn\u00fc kontrol edin\"><\/figure><\/div><p> Ve sonunda DO\u011eRU ve YANLI\u015e&#8217;\u0131 1 ve 0&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00e7ift eksi i\u015faretini kullanman\u0131z gerekir. \u015eimdi \u015fu \u015fekilde g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifier-la-deuxieme-partie-de-la-formule-avec-le-signe-moins-dans-la-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu s\u0131ralama i\u00e7in sumproduct varsa s\u0131ralamay\u0131 olu\u015fturmak i\u00e7in eksi oturum a\u00e7ma veri tablosunun bulundu\u011fu form\u00fcl\u00fcn ikinci b\u00f6l\u00fcm\u00fcn\u00fc kontrol edin\"><\/figure><\/div><p> Form\u00fcl\u00fcn bu b\u00f6l\u00fcm\u00fcn\u00fcn sonucu: Puan\u0131n b\u00fcy\u00fck oldu\u011fu yerde 1, e\u015fit veya k\u00fc\u00e7\u00fck oldu\u011fu yerde ise 0 var.<\/p><h3 id=\"h-part-3-multiply-two-arrays\" class=\"wp-block-heading\"> B\u00f6l\u00fcm 3: \u0130ki diziyi \u00e7arpma<\/h3><p> \u015eimdi derin bir nefes al\u0131n ve rahatlay\u0131n. Zihninizi yava\u015flat\u0131n ve \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcn. Bu noktada iki farkl\u0131 tablomuz var.<\/p><ol><li> \u0130lk tabloda konunun e\u015fle\u015fti\u011fi t\u00fcm de\u011ferler i\u00e7in 1, e\u015fle\u015fmiyorsa 0 de\u011feriniz vard\u0131r.<\/li><li> \u0130kinci tabloda \u00f6\u011frencilerin puan\u0131n\u0131n daha y\u00fcksek oldu\u011fu ve e\u015fit veya d\u00fc\u015f\u00fckse s\u0131f\u0131r oldu\u011fu t\u00fcm de\u011ferler i\u00e7in bir tane bulunur.<\/li><\/ol><p> Art\u0131k SUMproduct bu iki tabloyu \u00e7arpt\u0131\u011f\u0131nda yaln\u0131zca konu e\u015fle\u015fmeleri ve puan\u0131 Tameka&#8217;dan y\u00fcksek olan \u00f6\u011frenciler i\u00e7in 1 elde edeceksiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifiez-les-deux-parties-de-la-formule-dans-le-tableau-de-donnees-pour-creer-un-classement-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ko\u015fullu s\u0131ralama i\u00e7in sumproduct ile s\u0131ralama olu\u015fturmak i\u00e7in veri tablosundaki form\u00fcl\u00fcn her iki b\u00f6l\u00fcm\u00fcn\u00fc de kontrol edin\"><\/figure><\/div><p> \u015euna bak\u0131n, finans alan\u0131nda Tameka&#8217;dan daha iyi notlara sahip 9 \u00f6\u011frenci daha var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/le-nombre-detudiants-a-plus-de-points-verifier-avec-la-formule-du-tableau-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Ko\u015fullu s\u0131ralama i\u00e7in toplam \u00e7arp\u0131m kullan\u0131l\u0131yorsa, s\u0131ralamay\u0131 olu\u015fturmak i\u00e7in veri tablosu form\u00fcl\u00fcn\u00fc kullanarak daha fazla puana sahip \u00f6\u011frenci say\u0131s\u0131n\u0131 kontrol edin\"><\/figure><\/div><h3 id=\"h-part-4-adding-one\" class=\"wp-block-heading\"> B\u00f6l\u00fcm 4: + B\u0130R Ekle<\/h3><p> Son form\u00fcle neden 1 eklemeniz gerekti\u011fini merak ediyorsan\u0131z nedeni \u015fu: Bu noktada notlar\u0131 Tameka&#8217;n\u0131n \u00fczerinde olan toplam 9 \u00f6\u011frenci oldu\u011funu biliyorsunuz.<\/p><p> Yani 9 \u00f6\u011frenci varsa Tameka 10. s\u0131rada olmal\u0131. Bu y\u00fczden form\u00fcl\u00fcn sonuna 1 eklemeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/final-avec-la-formule-dans-la-table-de-donnees-pour-creer-un-rang-si-avec-sumproduct-pour-le-classement-conditionnel-1.png\" sizes=\"\" srcset=\"\" alt=\"Ko\u015fullu s\u0131ralama i\u00e7in sumproduct varsa s\u0131ralamay\u0131 olu\u015fturmak i\u00e7in veri tablosundaki form\u00fclle final\"><\/figure><\/div><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/rang-si.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><\/div><\/div><\/div><\/div><h2 id=\"h-conclusion\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Bana sorarsan\u0131z SUMproduct&#8217;\u0131n Excel k\u00fct\u00fcphanesindeki <a style=\"outline: none; display: inline-block;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\">en g\u00fc\u00e7l\u00fc fonksiyonlardan<\/a> biri oldu\u011funu ve yukar\u0131da kulland\u0131\u011f\u0131m\u0131z y\u00f6ntemin basit ve etkili oldu\u011funu d\u00fc\u015f\u00fcn\u00fcyorum.<\/p><p> SUMproduct ile uzun i\u00e7 i\u00e7e ko\u015fullu form\u00fcller yazman\u0131za gerek yoktur. Ko\u015fullu dereceler eklemek i\u00e7in bu sihir numaras\u0131na ihtiyac\u0131n\u0131z var. Umar\u0131m bu ipucu i\u015finizde size yard\u0131mc\u0131 olur ve \u015fimdi bana bir \u015fey s\u00f6yleyin.<\/p><p> RANKIF&#8217;i kullanman\u0131n ba\u015fka bir y\u00f6ntemini biliyor musunuz?<\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><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\/iki-hucreyi-karsilastir\/\">Excel&#8217;deki iki h\u00fccreyi kar\u015f\u0131la\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urundeki-durum\/\">SUMproduct IF Excel&#8217;de ko\u015fullu form\u00fcl olu\u015fturmak i\u00e7in<\/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-1651","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 2023&#039;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama<\/title>\n<meta name=\"description\" content=\"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz\" \/>\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\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 2023&#039;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama\" \/>\n<meta property=\"og:description\" content=\"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\",\"name\":\"\u25b7 2023&#39;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png\",\"datePublished\":\"2023-11-13T17:56:54+00:00\",\"dateModified\":\"2023-12-10T06:01:33+00:00\",\"description\":\"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ko\u015fullu s\u0131ralama nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@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 2023&#39;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama","description":"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz","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\/kosullu-siralama-toplami-carpim-siralamasi-eger\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 2023&#39;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama","og_description":"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz","og_url":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/","url":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/","name":"\u25b7 2023&#39;te Excel RANKIF i\u015flevinde ko\u015fullu s\u0131ralama","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png","datePublished":"2023-11-13T17:56:54+00:00","dateModified":"2023-12-10T06:01:33+00:00","description":"\u00d6ncelikle bunu benim i\u00e7in yap\u0131n, Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 a\u00e7\u0131n ve RANKIF yazmay\u0131 deneyin. Hi\u00e7bir i\u015flevi olup olmad\u0131\u011f\u0131n\u0131 merak edeceksiniz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tapez-rang-si-dans-excel-pour-le-classement-conditionnel-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ko\u015fullu s\u0131ralama nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/1651","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=1651"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1651\/revisions"}],"predecessor-version":[{"id":2537,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1651\/revisions\/2537"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}