{"id":1615,"date":"2023-11-15T10:25:02","date_gmt":"2023-11-15T10:25:02","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/toplam-4\/"},"modified":"2023-12-10T05:59:39","modified_gmt":"2023-12-10T05:59:39","slug":"toplam-4","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/toplam-4\/","title":{"rendered":"Excel i\u015flevi: etopla"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3561675123\"><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> <div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"0-intro-sumif-function\" class=\"wp-block-heading\"> Giri\u015f: ETOPLA i\u015flevi<\/h2><p> Excel&#8217;de ETOPLA i\u015flevini kulland\u0131\u011f\u0131n\u0131zda, belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan de\u011ferlerin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Ko\u015fulun kontrol edilece\u011fi h\u00fccre aral\u0131\u011f\u0131n\u0131, ard\u0131ndan ko\u015ful olarak kontrol edilecek de\u011feri ve son olarak da de\u011ferlerin toplanaca\u011f\u0131 aral\u0131\u011f\u0131 belirtmeniz gerekir. Bu nedenle belirtilmesi gereken \u00fc\u00e7 arg\u00fcman vard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"1-syntax\" class=\"wp-block-heading\"> S\u00f6zdizimi<\/h2><p> ETOPLA(aral\u0131k; \u00f6l\u00e7\u00fct; [toplam_aral\u0131k]) <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"2-arguments\" class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h2><ul><li> <strong>aral\u0131k<\/strong> : Kriterleri kontrol etmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>kriterler<\/strong> : say\u0131, metin, ifade, h\u00fccre referans\u0131 veya i\u015flev olabilen bir kriter.<\/li><li> <strong>[sum_range]<\/strong> : Toplamak istedi\u011finiz de\u011ferleri i\u00e7eren bir h\u00fccre aral\u0131\u011f\u0131. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"3-example\" class=\"wp-block-heading\"> \u00d6rnek<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte kriter aral\u0131\u011f\u0131 olarak A1:A9&#8217;u, toplam aral\u0131\u011f\u0131 olarak da B1:B9&#8217;u belirledik ve ard\u0131ndan C de\u011ferine sahip A12&#8217;de kriterleri belirledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-1\" width=\"416\" height=\"469\"><\/figure><\/div><p> Kriterleri do\u011frudan fonksiyona da ekleyebilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte &#8220;S&#8221; alfabesine sahip bir kriteri belirtmek i\u00e7in y\u0131ld\u0131z i\u015fareti joker karakteri kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-2\" width=\"457\" height=\"488\"><\/figure><\/div><p> Ve e\u011fer toplam aral\u0131\u011f\u0131n\u0131 g\u00f6z ard\u0131 ederseniz, bu size \u00f6l\u00e7\u00fct aral\u0131\u011f\u0131n\u0131n toplam\u0131n\u0131 verecektir. Ancak bu ancak kriter aral\u0131\u011f\u0131n\u0131n say\u0131sal de\u011ferlere sahip olmas\u0131 durumunda m\u00fcmk\u00fcn olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-3\" width=\"449\" height=\"450\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> <em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-2.xlsx\">\u00d6rnek bir dosya indirin<\/a><\/em> <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 id=\"4-related\" class=\"wp-block-heading\"> Daha fazla e\u011fitim<\/h2><ul><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterli-sutif\/\">Excel&#8217;de joker karakterlerle ETOPLA<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\">Excel&#8217;de iki tarih aras\u0131ndaki de\u011ferlerin toplam\u0131<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/tr\/sumif-sumifler-veya-mantik\/\">Excel&#8217;de VEYA mant\u0131\u011f\u0131yla ETOPLA\/TOPLA<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/tr\/toplamlar-esit-degil\/\">Excel&#8217;de e\u015fit olmayan de\u011ferlerin toplam\u0131 (SUMIFS)<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/tr\/toplamindan-buyukse\/\">Excel&#8217;de ETOPLA kullanarak daha b\u00fcy\u00fck de\u011ferleri toplay\u0131n<\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> \u0130lgili i\u015flevler<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-2\/\">Excel TOPLA i\u015flevi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urun-2\/\">Excel i\u015flevi TOPLA \u00c7ARPIM<\/a><\/li><\/ul><\/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-1615","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>Excel&#039;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#039;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.\" \/>\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\/toplam-4\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#039;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/toplam-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/\",\"name\":\"Excel&#39;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"datePublished\":\"2023-11-15T10:25:02+00:00\",\"dateModified\":\"2023-12-10T05:59:39+00:00\",\"description\":\"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#39;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/toplam-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel i\u015flevi: etopla\"}]},{\"@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":"Excel&#39;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)","description":"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#39;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.","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\/toplam-4\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)","og_description":"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#39;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.","og_url":"https:\/\/exceladvisor.org\/tr\/toplam-4\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/","url":"https:\/\/exceladvisor.org\/tr\/toplam-4\/","name":"Excel&#39;de ETOPLA \u0130\u015flevi (H\u0131zl\u0131 Excel E\u011fitimi)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","datePublished":"2023-11-15T10:25:02+00:00","dateModified":"2023-12-10T05:59:39+00:00","description":"Bu e\u011fitimde, bir \u00f6l\u00e7\u00fct kullanarak de\u011fer eklemek i\u00e7in Excel&#39;in ETOPLA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/toplam-4\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/toplam-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel i\u015flevi: etopla"}]},{"@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\/1615","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=1615"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1615\/revisions"}],"predecessor-version":[{"id":2342,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1615\/revisions\/2342"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}