{"id":1638,"date":"2023-11-14T15:02:28","date_gmt":"2023-11-14T15:02:28","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/"},"modified":"2023-12-10T06:04:21","modified_gmt":"2023-12-10T06:04:21","slug":"iki-tarih-arasindaki-degerlerin-toplami","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/","title":{"rendered":"I\u0307ki tarih tablosu nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1454954124\"><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>Evet, do\u011fru duydunuz SUMIFS, iki tarih (yani tarih aral\u0131\u011f\u0131) aras\u0131na de\u011fer eklemenin en basit ve en iyi y\u00f6ntemidir.<\/p><p> Sana bir \u015fey s\u00f6yleyeyim. Diyelim ki bir ticaret \u015firketinde \u00e7al\u0131\u015f\u0131yorsunuz ve patronunuz sizden son 15 g\u00fcn\u00fcn toplam sat\u0131\u015f tutar\u0131n\u0131 alman\u0131z\u0131 istiyor.<\/p><p> Bu durumda g\u00fcncel tarihten 15 g\u00fcn \u00f6ncesine kadar yani iki tarih aras\u0131ndaki sat\u0131\u015f tutar\u0131n\u0131 eklemeniz gerekir. Nas\u0131l oldu\u011funu s\u00f6yleyeyim. Burada toplam 15 g\u00fcn\u00fc kapsayan iki tarih aral\u0131\u011f\u0131n\u0131z var ve her birine ait de\u011ferleri eklemeniz gerekiyor.<\/p><p> Ve SUMIFS ile bu iki tarihi kriter olarak ekleyebilirsiniz ve bir aral\u0131k gibi \u00e7al\u0131\u015f\u0131r ve o aral\u0131k aras\u0131ndaki t\u00fcm de\u011ferleri toplar.<\/p><p class=\"qt-tip\"> <strong>H\u0131zl\u0131 giri\u015f:<\/strong> SUMIFS, birden fazla kriter belirterek de\u011fer eklemenize yard\u0131mc\u0131 olabilir. K\u0131saca sadece t\u00fcm \u015fartlar\u0131n sa\u011fland\u0131\u011f\u0131 h\u00fccreleri \u00f6zetleyecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(sum_range,range1,criteria1,[range2],[criteria2],\u2026)<\/code><\/pre><p> Yukar\u0131daki s\u00f6zdiziminde, \u00f6nce de\u011ferleri toplamak istedi\u011finiz aral\u0131\u011fa, ard\u0131ndan kriterleri kontrol etmek i\u00e7in aral\u0131\u011fa ve ard\u0131ndan kontrol edilecek kritere vb. ba\u015fvurman\u0131z gerekir.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de iki tarih aras\u0131na de\u011fer ekleme form\u00fcl\u00fc<\/h2><p> Burada Ocak ay\u0131na ait sat\u0131\u015f verileriniz var ve 15 Ocak 2017 ile 25 Ocak 2017 aras\u0131ndaki de\u011ferleri toplaman\u0131z gerekiyor. <\/p><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-des-valeurs-entre-deux-donnees-de-dates.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a> <\/div><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"SUMIFS kullanarak iki tarih aras\u0131na de\u011fer eklemek i\u00e7in veriler\"><\/figure><\/div><p> D2 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc ekleyin ve Enter tu\u015funa bas\u0131n:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(B2:B31,A2:A31,\"&gt;=15-Jan-2017\",A2:A31,\"&lt;=25-Jan-2017\")<\/code><\/pre><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda, bu i\u015flev h\u00fccrede 15 Ocak 2017 ile 25 Ocak 2017 aras\u0131ndaki tutar\u0131n toplam\u0131 olan 15.682 ABD dolar\u0131n\u0131 d\u00f6nd\u00fcrecektir. Ve burada bu hesaplamaya ba\u015flang\u0131\u00e7 ve biti\u015f tarihlerini de dahil ettiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"iki tarih aras\u0131na de\u011fer ekleme form\u00fcl\u00fc\"><\/figure><\/div><p> Bu hesaplamay\u0131 kontrol etmek i\u00e7in 15 Ocak 2017&#8217;den 25 Ocak 2017&#8217;ye kadar olan miktar h\u00fccrelerini se\u00e7in ve bu de\u011ferlerin toplam\u0131 i\u00e7in durum \u00e7ubu\u011funu kontrol edin veya kontrol etmek i\u00e7in de\u011ferleri de filtreleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifier-la-somme-de-la-barre-detat-pour-verifier-que-la-somme-des-valeurs-entre-les-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tarihler aras\u0131ndaki de\u011ferlerin toplam\u0131n\u0131n do\u011fru oldu\u011funu do\u011frulamak i\u00e7in durum \u00e7ubu\u011funun toplam\u0131n\u0131 kontrol edin\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \u0130\u015fte nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fclde, toplam\u0131 hesaplarken bir ko\u015ful eklememize olanak tan\u0131yan SUMIFS ile mant\u0131ksal operat\u00f6rleri kulland\u0131k. Anlamak i\u00e7in form\u00fcl\u00fc par\u00e7alayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-cette-formule-fonctionne-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Bu form\u00fcl iki tarih aras\u0131ndaki de\u011ferleri toplamak i\u00e7in nas\u0131l \u00e7al\u0131\u015f\u0131r?\"><\/figure><\/div><ul><li> \u00d6ncelikle tutar\u0131n bulundu\u011fu yerde toplam_aral\u0131k olarak B2:B31 aral\u0131\u011f\u0131n\u0131 kulland\u0131k.<\/li><li> <span style=\"color: #000000;\">Daha sonra<\/span> ilk kriter aral\u0131\u011f\u0131 olarak A2:A31, ilk kriter olarak ise \u201c&gt;=15-Jan-2017\u201d ifadesini kulland\u0131k.<\/li><li> Daha sonra tekrar A2:A31 referans\u0131n\u0131 verdik ama bu sefer ikinci kriter aral\u0131\u011f\u0131 olarak ve \u201c&lt;=25-Ocak-2017\u201d ikinci kriter olarak.<\/li><\/ul><p> Dolay\u0131s\u0131yla bu iki kriter, fonksiyona 15 Ocak 2017&#8217;ye e\u015fit veya daha b\u00fcy\u00fck ve 25 Ocak 2017&#8217;ye e\u015fit veya daha k\u00fc\u00e7\u00fck de\u011ferleri toplamas\u0131n\u0131 s\u00f6yler.<\/p><p> Yani bu <strong><span style=\"color: #000000;\">noktada<\/span><\/strong> tarih aral\u0131\u011f\u0131n\u0131 olu\u015fturan alt limit ve \u00fcst limit olmak \u00fczere iki farkl\u0131 kriterimiz var. Ve fonksiyon yaln\u0131zca bu aral\u0131ktaki de\u011ferleri toplayacakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> <span style=\"color: #ea493f;\">Dinamik bir tarih aral\u0131\u011f\u0131<\/span> aras\u0131ndaki de\u011ferlerin toplam\u0131<\/h2><p> \u0130ki tarih aras\u0131na s\u00fcrekli de\u011fer eklemeniz gereken zamanlar olabilir. Diyelim ki son 7 g\u00fcn\u00fcn de\u011ferlerini toplaman\u0131z gerekiyor ve dinamik olmas\u0131 gerekiyor ki her g\u00fcn son 7 g\u00fcn\u00fcn toplam\u0131n\u0131 alabilesiniz. Yani form\u00fcller \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(B2:B31,A2:A31,\"&lt;=\"&amp;TODAY(),A2:A31,\"&gt;=\"&amp;(TODAY()-6))<\/code><\/pre><h3 class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Yukar\u0131daki form\u00fclde, otomatik olarak de\u011fi\u015fecek olan g\u00fcncel dinamik tarihi elde etmek i\u00e7in BUG\u00dcN fonksiyonunu kulland\u0131k. \u0130lk kriter, fonksiyona yaln\u0131zca bug\u00fcn\u00fcn tarihine e\u015fit veya bu tarihten k\u00fc\u00e7\u00fck de\u011ferleri eklemesini s\u00f6yler.<\/p><p> <span style=\"color: #000000;\">\u0130kinci<\/span> kriter ise fonksiyona yaln\u0131zca bug\u00fcnden 6 g\u00fcn \u00f6nceki tarihe e\u015fit veya bu tarihten daha k\u00fc\u00e7\u00fck de\u011ferleri toplamas\u0131n\u0131 s\u00f6yler.<\/p><p> <span style=\"color: #000000;\"><strong>\u015eimdi<\/strong><\/span> iki tarihin aral\u0131\u011f\u0131 \u015funa benzer olacakt\u0131r: <strong>bug\u00fcnden alt\u0131 g\u00fcn \u00f6ncesine kadar<\/strong> , bu da toplam yedi g\u00fcn\u00fcn\u00fcz oldu\u011fu anlam\u0131na gelir. Ve fonksiyon yaln\u0131zca bu aral\u0131ktaki de\u011ferleri toplayacakt\u0131r. <\/p><div class=\"gb-container gb-container-9b8f593d gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e7dd4817 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e0766fef gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-des-valeurs-entre-deux-dates-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/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\/toplam-gorunumu\/\">D\u00dc\u015eEYARA&#8217;y\u0131 ETOPLA ile birle\u015ftirme<\/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-1638","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>\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131<\/title>\n<meta name=\"description\" content=\"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli\" \/>\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\/iki-tarih-arasindaki-degerlerin-toplami\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131\" \/>\n<meta property=\"og:description\" content=\"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\",\"name\":\"\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\",\"datePublished\":\"2023-11-14T15:02:28+00:00\",\"dateModified\":\"2023-12-10T06:04:21+00:00\",\"description\":\"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"I\u0307ki tarih tablosu 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":"\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131","description":"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli","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\/iki-tarih-arasindaki-degerlerin-toplami\/","og_locale":"tr_TR","og_type":"article","og_title":"\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131","og_description":"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli","og_url":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.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\/iki-tarih-arasindaki-degerlerin-toplami\/","url":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/","name":"\u00c7OKETOPLA: \u0130ki tarih tablosu aras\u0131ndaki de\u011ferlerin toplam\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png","datePublished":"2023-11-14T15:02:28+00:00","dateModified":"2023-12-10T06:04:21+00:00","description":"SUMIFS, iki tarih aras\u0131na denk gelen de\u011ferleri eklemenin en iyi yoludur. Sadece alt tarihi belirtmeniz yeterli","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-additionner-les-valeurs-entre-deux-dates-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"I\u0307ki tarih tablosu 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\/1638","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=1638"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1638\/revisions"}],"predecessor-version":[{"id":2715,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1638\/revisions\/2715"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}