{"id":1722,"date":"2023-11-09T19:18:18","date_gmt":"2023-11-09T19:18:18","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/"},"modified":"2023-12-10T06:08:06","modified_gmt":"2023-12-10T06:08:06","slug":"sumif-yil-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/","title":{"rendered":"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1474534638\"><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>Excel&#8217;de belirli bir y\u0131la dayal\u0131 de\u011ferleri toplamak i\u00e7in izlenecek iki y\u00f6ntem verdik. \u0130lk y\u00f6ntem, o s\u00fctunun ay\u0131na g\u00f6re y\u0131l numaras\u0131n\u0131 ve toplam de\u011ferlerini i\u00e7eren bir s\u00fctun eklemeniz gereken bir yard\u0131mc\u0131 s\u00fctun kullan\u0131r.<\/p><p> \u0130kinci y\u00f6ntem farkl\u0131 bir yakla\u015f\u0131m kullan\u0131r. Tarih s\u00fctunundan aylar\u0131 \u00e7\u0131kararak tablo olu\u015fturmak i\u00e7in daha sonra o tablodan y\u0131l bazl\u0131 de\u011ferleri toplay\u0131n.<\/p><p> Bu dersimizde y\u0131l baz\u0131nda de\u011fer eklemenin her iki y\u00f6ntemini de \u00f6\u011frenece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Yard\u0131mc\u0131 s\u00fctunlu ETOPLA y\u0131l\u0131<\/h2><ol><li> \u00d6ncelikle yeni bir s\u00fctun ekleyin ve tarihlerden y\u0131l say\u0131s\u0131n\u0131 almak i\u00e7in YIL fonksiyonuna girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"1 y\u0131l g\u00f6revde\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"year-function\" width=\"436\" height=\"327\"><\/li><li> \u015eimdi bir sonraki s\u00fctuna gidin ve oraya SUMIFS fonksiyonunu girin.<\/li><li> ETOPLA i\u015flevinde aral\u0131k ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni i\u00e7in y\u0131l s\u00fctununa bak\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-ba\u015fvuru-y\u0131l-toplam s\u00fctunu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-referez-vous-a-la-colonne-de-lannee-dans-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer-year-column-in-sumif\" width=\"546\" height=\"256\"><\/li><li> Daha sonra \u00f6l\u00e7\u00fct ba\u011f\u0131ms\u0131z de\u011fi\u015fkenine de\u011ferleri eklemek i\u00e7in kullanmak istedi\u011finiz y\u0131l\u0131 girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 y\u0131ll\u0131k tart\u0131\u015fmada\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-lannee-en-argument.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-year-in-argument\" width=\"544\" height=\"260\"><\/li><li> Sonunda, toplam_aral\u0131k i\u00e7in miktar s\u00fctununa bak\u0131n, kapan\u0131\u015f parantezlerini girin ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-referans miktar\u0131 s\u00fctunu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-colonne-de-quantite-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer-quantity-column\" width=\"549\" height=\"263\"><\/li><\/ol><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda kar\u015f\u0131n\u0131za kriterlerde belirtti\u011finiz gibi 2021 y\u0131l\u0131na ait de\u011ferlerin toplam\u0131 \u00e7\u0131k\u0131yor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77859\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-valeurs-de-somme-pour-lannee-en-argument.png\" sizes=\"auto, \" srcset=\"\" alt=\"arg\u00fcmandaki y\u0131l\u0131n toplam de\u011ferleri\" width=\"509\" height=\"432\"><\/figure><\/div><p class=\"formula\"> =TOPLA(C1:C16,2021,B1:B16)<\/p><h2 class=\"wp-block-heading\"> Y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in SUMproduct kullan\u0131n<\/h2><p> SUMproduct kullanarak form\u00fcl olu\u015fturmak \u00e7ok daha g\u00fc\u00e7l\u00fcd\u00fcr. Bu form\u00fclle yard\u0131mc\u0131 s\u00fctun eklemenize gerek yoktur.<\/p><ol><li> \u00d6ncelikle SUMproduct fonksiyonuna girin ve \u00e7ift eksi i\u015faretini \u201c-\u201c girin.<\/li><li> Bundan sonra y\u0131l fonksiyonunu girin ve tarihlerinizin oldu\u011fu aral\u0131\u011f\u0131n tamam\u0131na bak\u0131n.<\/li><li> Daha sonra e\u015fittir i\u015fareti kullan\u0131n ve toplam i\u00e7in kullanmak istedi\u011finiz y\u0131l de\u011ferini kullanarak girin.<\/li><li> Buradan itibaren parantez i\u00e7inde y\u0131l g\u00f6sterilmektedir.<\/li><li> \u015eimdi SUMproduct&#8217;\u0131n ikinci arg\u00fcman\u0131nda eklemek istedi\u011finiz de\u011ferlerin bulundu\u011fu aral\u0131\u011fa bak\u0131n.<\/li><li> Sonunda sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77860\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sommeproduit-a-somme-basee-sur-lannee.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u0131la dayal\u0131 olarak toplam\u0131n toplanmas\u0131\" width=\"539\" height=\"430\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(YEAR(A2:A16)=2021),B2:B16)<\/code><\/pre><p> Bu form\u00fcl\u00fc anlamak i\u00e7in onu \u00fc\u00e7 par\u00e7aya b\u00f6lmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77861\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-comprendre-la-formule-du-produit-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"Toplam\u0131n \u00e7arp\u0131m\u0131n\u0131n form\u00fcl\u00fcn\u00fc anlay\u0131n\" width=\"558\" height=\"279\"><\/figure><\/div><p> \u0130lk b\u00f6l\u00fcmde tarih fonksiyonunda 2021 y\u0131l\u0131n\u0131 kontrol etme ko\u015fuluyla y\u0131l fonksiyonuna sahipsiniz. Bu ko\u015ful, tarihte sahip oldu\u011funuz y\u0131la ba\u011fl\u0131 olarak DO\u011eRU ve YANLI\u015e dizisini d\u00f6nd\u00fcr\u00fcr. Bir tarih 2021 y\u0131l\u0131na sahipse DO\u011eRU, aksi halde YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77862\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Condition-de-fonctionnement-de-8-ans-en-premiere-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u0131l-fonksiyon-ko\u015ful-ilk-b\u00f6l\u00fcmde\" width=\"576\" height=\"355\"><\/figure><\/div><p> \u0130kinci k\u0131s\u0131mda DO\u011eRU ve YANLI\u015e de\u011ferlerini s\u0131ras\u0131yla 1 ve 0&#8217;a d\u00f6n\u00fc\u015ft\u00fcren iki eksi i\u015faretiniz (-) bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77863\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-deuxieme-partie-a-deux-signes-moins.png\" sizes=\"auto, \" srcset=\"\" alt=\"ikinci-b\u00f6l\u00fcmde-iki-eksi-i\u015fareti var\" width=\"602\" height=\"344\"><\/figure><\/div><p> \u00dc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcmde, biri 0 (2021 y\u0131l\u0131 i\u00e7in) ve 1 (2021 y\u0131l\u0131 d\u0131\u015f\u0131ndaki y\u0131llar i\u00e7in), di\u011feri ise aral\u0131\u011f\u0131n toplam de\u011ferlerini i\u00e7eren iki tabloya sahipsiniz. SUMproduct iki diziyi birbiriyle \u00e7arpar ve bu de\u011ferleri toplar.<\/p><p> \u015eimdi anlaman\u0131z gereken bir \u015fey var: S\u0131f\u0131r\u0131 herhangi bir de\u011ferle \u00e7arpt\u0131\u011f\u0131n\u0131zda 0 d\u00f6nd\u00fcr\u00fcr. Yani elinizde yaln\u0131zca ilk dizide 1&#8217;in oldu\u011fu de\u011ferler kal\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77864\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-troisieme-partie-a-deux-fleches.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki oklu \u00fc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcm\" width=\"474\" height=\"182\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/annee-sumif.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><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\/toplamindan-buyukse\/\">SUMIF kullanarak de\u011ferlerden daha b\u00fcy\u00fck toplam<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplamlar-esit-degil\/\">Excel&#8217;de e\u015fit olmayan de\u011ferlerin toplam\u0131 (SUMIFS)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sumif-sumifler-veya-mantik\/\">Excel&#8217;de VEYA mant\u0131\u011f\u0131yla ETOPLA\/TOPLA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterli-sutif\/\">Excel&#8217;de joker karakterlerle ETOPLA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\">SUMIFS tarih aral\u0131\u011f\u0131 (iki tarih dizisi aras\u0131ndaki de\u011ferlerin toplam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-gorunumu\/\">D\u00dc\u015eEYARA&#8217;y\u0131 ETOPLA ile birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iceriyorsa-toplami\/\">Toplam E\u011eER h\u00fccre belirli bir metin i\u00e7eriyorsa (SUMIF k\u0131smi metin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarihe-gore-toplam\/\">Tarihe g\u00f6re ETOPLA (bir tarihe dayal\u0131 de\u011ferlerin toplam\u0131)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-degilse-toplam-2\/\">Bo\u015f olmayan SUMIF (bo\u015f olmayan h\u00fccreler i\u00e7in toplam de\u011ferler)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bossa-toplam-2\/\">Bo\u015f de\u011ferleri veya bo\u015f h\u00fccreleri toplamak i\u00e7in SUMIF kullan\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-daha-azsa-toplam\/\">Belirli bir de\u011ferden k\u00fc\u00e7\u00fck de\u011ferlerin toplam\u0131 (SUMIF k\u00fc\u00e7\u00fckt\u00fcr)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sifirdan-buyukse-toplam-2\/\">S\u0131f\u0131rdan b\u00fcy\u00fck de\u011ferlerin toplam\u0131 (SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\">Aya g\u00f6re de\u011ferlerin toplam\u0131 (SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/grup-basina-toplam-2\/\">Grup ba\u015f\u0131na de\u011ferlerin toplam\u0131<\/a><\/li><\/ul><\/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-1722","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>Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)<\/title>\n<meta name=\"description\" content=\"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz\" \/>\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\/sumif-yil-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)\" \/>\n<meta property=\"og:description\" content=\"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:08:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/\",\"name\":\"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png\",\"datePublished\":\"2023-11-09T19:18:18+00:00\",\"dateModified\":\"2023-12-10T06:08:06+00:00\",\"description\":\"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir?\"}]},{\"@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":"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)","description":"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz","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\/sumif-yil-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)","og_description":"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz","og_url":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:08:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/","url":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/","name":"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir? (2023 K\u0131lavuzu)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png","datePublished":"2023-11-09T19:18:18+00:00","dateModified":"2023-12-10T06:08:06+00:00","description":"Bu dersimizde y\u0131la g\u00f6re de\u011fer eklemek i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz. Bunun i\u00e7in biz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-fonction.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Y\u0131llara g\u00f6re de\u011ferler nas\u0131l eklenir?"}]},{"@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\/1722","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=1722"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1722\/revisions"}],"predecessor-version":[{"id":2969,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1722\/revisions\/2969"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}