{"id":1752,"date":"2023-11-07T01:38:23","date_gmt":"2023-11-07T01:38:23","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/"},"modified":"2023-12-10T06:01:05","modified_gmt":"2023-12-10T06:01:05","slug":"2-ise-alt-toplam","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/","title":{"rendered":"Excel&#39;de if ile subtotal nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2284057149\"><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><strong>BU FORM\u00dcL SAF B\u0130R S\u0130H\u0130RD\u0130R.<\/strong><\/p><p> Excel&#8217;de IF (ko\u015ful) ile ALTTOPLAM form\u00fcl\u00fc yazmak istiyorsan\u0131z, bunu yapmak i\u00e7in \u00e7e\u015fitli i\u015flevleri kullanman\u0131z gerekir. Ancak bunu yapmadan \u00f6nce bu \u00f6rnek i\u00e7in elimizdeki verileri anlayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82611\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"if ile alt toplam\" width=\"720\" height=\"334\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte \u00fc\u00e7 s\u00fctununuz var:<\/p><ul><li> \u0130sim<\/li><li> Ya\u015f levhas\u0131<\/li><li> Cinsiyet<\/li><\/ul><p> Ya\u015f Tablosu s\u00fctunundan bir d\u00f6\u015femeyi filtreledi\u011finizde F1 h\u00fccresindeki kad\u0131n say\u0131s\u0131 g\u00f6r\u00fcnt\u00fclenir. Yani bu, filtrelenen de\u011ferlerin say\u0131s\u0131n\u0131 ancak bir ko\u015fulla g\u00f6r\u00fcnt\u00fcleyen bir form\u00fcl\u00fcm\u00fcz oldu\u011fu anlam\u0131na gelir.<\/p><p> Elimizdeki form\u00fcl:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT((C2:C41=E1)*(SUBTOTAL(3,OFFSET(C2,ROW(C2:C41)-MIN(ROW(C2:C41)),0))))<\/code><\/pre><h2 class=\"wp-block-heading\"> ALTTOPLAM IF form\u00fcl\u00fcn\u00fc anlama<\/h2><p> Bu form\u00fcl be\u015f i\u015flevi kullan\u0131r: TOPLAM \u00c7ARPIM, ALTTOPLAM, KAYDIRMA, SATIR ve MAKS. Bu nedenle bu form\u00fcl\u00fc anlamak i\u00e7in onu birka\u00e7 par\u00e7aya ay\u0131rmam\u0131z gerekiyor.<\/p><h3 class=\"wp-block-heading\"> 1.SATIR(C2:C41)-2.0)<\/h3><p> Form\u00fcl\u00fcn bu k\u0131sm\u0131 MIN ve SATIR i\u015flevlerini kullan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82621\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-min-et-fonction-rangee1.png\" sizes=\"auto, \" srcset=\"\" alt=\"minimum ve sat\u0131r i\u015flevi\" width=\"780\" height=\"110\"><\/figure><\/div><ul><li> SATIR&#8217;da &#8220;Cinsiyet&#8221; s\u00fctunlar\u0131na ba\u015fvuruda bulunduk ve bu, bir sat\u0131r numaras\u0131 dizisi d\u00f6nd\u00fcr\u00fcyor.<\/li><li> Bundan sonra MIN bu dizi veya sat\u0131r numaralar\u0131n\u0131 al\u0131r ve minimum sat\u0131r say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bu y\u00fczden form\u00fcl\u00fcn bu k\u0131sm\u0131nda 2 var.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2.SATIR(C2:C41)<\/h3><p> Bu b\u00f6l\u00fcmde yaln\u0131zca sat\u0131r numaralar\u0131n\u0131n bir dizisini d\u00f6nd\u00fcren ROW fonksiyonumuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82612\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-a-3-lignes-pour-renvoyer-un-tableau-de-numeros-de-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sat\u0131r-i\u015flevinden-sat\u0131r-say\u0131lar\u0131n\u0131n-d\u00f6n\u00fc\u015f dizisine\" width=\"726\" height=\"136\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. OFSET(C2,SATIR(C2:C41)-MIN(SATIR(C2:C41))),0)<\/h3><p> Art\u0131k OFFSET fonksiyonumuz var. Ba\u015flang\u0131\u00e7 noktas\u0131 olarak h\u00fccre referans\u0131n\u0131 kullanarak bir aral\u0131\u011fa referans olu\u015fturman\u0131za yard\u0131mc\u0131 olur. <strong>Referans<\/strong> arg\u00fcman\u0131nda cinsiyet aral\u0131\u011f\u0131m\u0131z\u0131n ba\u015flad\u0131\u011f\u0131 ilk h\u00fccre olan C2 h\u00fccresinden bahsettik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82613\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-decalage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ofset i\u015flevi\" width=\"489\" height=\"94\"><\/figure><\/div><p> \u00c7izgiler arg\u00fcman\u0131nda, yukar\u0131da ilk iki b\u00f6l\u00fcmde tart\u0131\u015f\u0131lan form\u00fcl\u00fcn bu k\u0131sm\u0131na sahibiz. Bundan sonra cols arg\u00fcman\u0131nda 0 kulland\u0131k. T\u00fcm bunlarla birlikte OFFSET, \u201cSex\u201d s\u00fctunundaki t\u00fcm de\u011ferlerin bir dizisini 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-82614\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-decalage-renvoie-la-valeur-des-colonnes-de-sexe.png\" sizes=\"auto, \" srcset=\"\" alt=\"cinsiyet s\u00fctunlar\u0131n\u0131n-de\u011feri-d\u00f6n\u00fc\u015fleri\" width=\"619\" height=\"207\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. ALTTOPLAM(3,KAYDIRMA(C2,SATIR(C2:C41)-MIN(SATIR(C2:C41))),0))<\/h3><p> ALTTOPLAM&#8217;da OFFSET&#8217;in d\u00f6nd\u00fcrd\u00fc\u011f\u00fc diziyi kulland\u0131k. Ve fonksiyon_numunda, SUBTOTAL&#8217;a hesaplama i\u00e7in COUNTA fonksiyonunu kullanmas\u0131n\u0131 s\u00f6yleyen 3&#8217;\u00fc kulland\u0131k.<\/p><p> &#8220;Ya\u015f D\u00f6\u015femesi&#8221; s\u00fctununda bir filtre kulland\u0131\u011f\u0131n\u0131zda, form\u00fcl\u00fcn bu ALTTOPLAM k\u0131sm\u0131 0 ve 1 i\u00e7eren bir dizi 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-82615\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sous-total-a-utiliser-counta.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131lacak ara toplam\" width=\"635\" height=\"140\"><\/figure><\/div><p> Bu tabloda filtreyi uygulad\u0131\u011f\u0131m\u0131z de\u011fere e\u015fde\u011fer de\u011ferler i\u00e7in 1 de\u011ferimiz var. A\u015fa\u011f\u0131daki \u00f6rne\u011fe bak\u0131n: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82616\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-valeurs-equivalentes-aux-valeurs-appliquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"uygulanan-de\u011ferlere-e\u015fde\u011fer de\u011ferler\" width=\"552\" height=\"247\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. (C2:C41=E1)<\/h3><p> Form\u00fcl\u00fcn bu k\u0131sm\u0131, bir ko\u015fulu test ederek bir dizi d\u00f6nd\u00fcr\u00fcr. Bu durumda aral\u0131k de\u011ferinin \u201cKad\u0131n\u201d olup olmad\u0131\u011f\u0131n\u0131 test ediyoruz ve dizide DO\u011eRU ve YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82617\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-renvoie-vrai-et-faux-dans-le-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizideki do\u011fru ve yanl\u0131\u015f\u0131 d\u00f6nd\u00fcr\u00fcr\" width=\"448\" height=\"320\"><\/figure><\/div><p> Bu tabloda \u201cKad\u0131n\u201d de\u011feri i\u00e7in DO\u011eRU, di\u011ferleri i\u00e7in YANLI\u015e de\u011ferini ald\u0131k.<\/p><h3 class=\"wp-block-heading\"> 7. Son b\u00f6l\u00fcm<\/h3><p> Sonu\u00e7 olarak SUMproduct&#8217;ta iki tablomuz var. Ayr\u0131ca bu diziler aras\u0131nda bir y\u0131ld\u0131z i\u015fareti operat\u00f6r\u00fcm\u00fcz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82618\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-deux-tableaux-en-sumproduct.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplamda iki tablo \u00fcretildi\" width=\"659\" height=\"151\"><\/figure><\/div><p> \u0130ki tabloyu birbiriyle \u00e7arpt\u0131\u011f\u0131m\u0131zda 0 ve 1&#8217;den olu\u015fan tek bir tablo elde ediyoruz. Bu tabloda bir (1) cinsiyette &#8220;Kad\u0131n&#8221; de\u011feri i\u00e7in, 21-30 ise &#8220;Ya\u015f Plakas\u0131&#8221; i\u00e7in ge\u00e7erlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82619\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-tableau-unique-avec-zero-et-un.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u0131f\u0131r ve bir i\u00e7eren tek dizi\" width=\"572\" height=\"84\"><\/figure><\/div><p> Sonunda SUMproduct bu diziyi kullanarak toplam\u0131 d\u00f6nd\u00fcr\u00fcr. Bu toplam da &#8220;Ya\u015f Aral\u0131\u011f\u0131&#8221; s\u00fctununda 21-30 aras\u0131 filtreleme yapt\u0131\u011f\u0131n\u0131zda cinsiyet s\u00fctununda &#8220;Kad\u0131n&#8221; de\u011ferini ta\u015f\u0131yan h\u00fccrelerin say\u0131s\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82620\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-sumproduct-renvoie-la-somme-en-utilisant-arroay1.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumproduct-diziyi-kullanarak-toplam\u0131 d\u00f6nd\u00fcr\u00fcr\" width=\"733\" height=\"340\"><\/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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/sous-total-si.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\/sifirsa-o-zaman-bos\/\">IF 0 (s\u0131f\u0131r) de\u011ferini kontrol edin ve ard\u0131ndan Excel&#8217;de bo\u015f b\u0131rak\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\">Excel&#8217;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve-1\/\">Excel&#8217;de E\u011eER ve VE i\u015flevlerini birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya-1\/\">Excel&#8217;de IF ve OR i\u015flevlerini birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-bossa\/\">IF H\u00fccresi Excel&#8217;de IF + ISBLANK kullan\u0131larak bo\u015f (bo\u015f)<\/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-1752","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 IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\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\/2-ise-alt-toplam\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.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\/2-ise-alt-toplam\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/\",\"name\":\"Excel&#39;de IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\",\"datePublished\":\"2023-11-07T01:38:23+00:00\",\"dateModified\":\"2023-12-10T06:01:05+00:00\",\"description\":\"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de if ile subtotal 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":"Excel&#39;de IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","description":"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","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\/2-ise-alt-toplam\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","og_description":"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.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\/2-ise-alt-toplam\/","url":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/","name":"Excel&#39;de IF ile SUBTOTAL nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png","datePublished":"2023-11-07T01:38:23+00:00","dateModified":"2023-12-10T06:01:05+00:00","description":"Bu e\u011fitim size, ALTTOPLAMI IF (Ko\u015fullu ALTTOPLAM) ile kullanmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de if ile subtotal 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\/1752","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=1752"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1752\/revisions"}],"predecessor-version":[{"id":2469,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1752\/revisions\/2469"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}