{"id":1735,"date":"2023-11-08T20:50:38","date_gmt":"2023-11-08T20:50:38","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/"},"modified":"2023-12-06T06:15:35","modified_gmt":"2023-12-06T06:15:35","slug":"jumlah-berdasarkan-tanggal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/","title":{"rendered":"Bagaimana cara menambahkan nilai berdasarkan tanggal?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2764726322\"><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>Untuk menggunakan SUMIF untuk menambahkan nilai berdasarkan tanggal sebagai kriteria, Anda bisa merujuk ke sel tempat Anda memiliki tanggal, atau Anda bisa memasukkan tanggal langsung ke dalam fungsinya. Di SUMIFS Anda memiliki argumen kriteria dan dalam argumen itu; Anda harus menentukan tanggal di mana Anda ingin menambahkan nilainya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-nilai-berdasarkan-tanggal\" width=\"451\" height=\"474\"><\/figure><\/div><p> Dalam tutorial ini, kita akan mempelajari cara menggunakan fungsi SUMIF Excel pada suatu tanggal.<\/p><h2 class=\"wp-block-heading\"> Gunakan SUMIF berdasarkan tanggal di Excel<\/h2><ol type=\"1\"><li> Pertama, masukkan <code>=SUMIF(<\/code> sel tempat Anda ingin menjumlahkannya.<\/li><li> Setelah itu lihat kolom tanggal, range A2:A15.<\/li><li> Kemudian, dalam argumen kriteria, referensikan sel tempat Anda memiliki tanggal.<\/li><li> Sekarang di argumen terakhir, lihat kolom jumlah, rentang B2:B15.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumif-par-date-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-menurut-tanggal-di-excel\" width=\"549\" height=\"465\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=SUMIF(A2:A15,D4,B2:B15)<\/code><\/pre><p> Dengan rumus di atas, Anda mendapatkan hasil penjumlahan untuk tanggal \u201c15-Okt-2022\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77818\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-si-par-date-result1.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-menurut-tanggal-hasil\" width=\"457\" height=\"447\"><\/figure><\/div><p> Anda juga bisa memasukkan tanggal dalam argumen fungsi sebagai nilai.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A15,\"15-Oct-2022\",B2:B15) =SUMIF(A2:A15,DATE(2022,10,15),B2:B15) =SUMIF(A2:A15,\"15-10-2022\",B2:B15)<\/code><\/pre><h2 class=\"wp-block-heading\"> SUM sebelum atau sesudah tanggal menggunakan SUMIF<\/h2><p> Anda juga dapat menggunakan operator logika dengan tanggal untuk ditambahkan sebelum atau sesudah tanggal tertentu. Dalam contoh berikut, kita memiliki tanda lebih besar dari tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77819\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-avant-ou-apres-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-sebelum-atau-sesudah-tanggal\" width=\"683\" height=\"443\"><\/figure><\/div><p> Saat Anda menekan Enter, ia kembali, 2028, yang merupakan total tanggal 15 November 2022. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77820\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-sumif-date-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil-tanggal sumif\" width=\"453\" height=\"446\"><\/figure><\/div><p> Demikian pula, Anda dapat menggunakan operator kurang dari (&lt;) untuk menjumlahkan berdasarkan tanggal yang kurang dari tanggal di sel D4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77821\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sumif-avec-signe-inferieur.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-dengan-tanda bawah\" width=\"369\" height=\"152\"><\/figure><\/div><p> Berikut beberapa operator lain yang dapat Anda gunakan:<\/p><ul><li> Berbeda dari &lt;&gt;<\/li><li> Lebih besar atau sama dengan &gt;=<\/li><li> Kurang dari dan sama dengan &lt;= <\/li><\/ul><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/dates-de-somme.xlsx\" rel=\"nofollow\">Unduh<\/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\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/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\/id\/jumlah-jika-lebih-besar-dari\/\">Jumlahnya lebih besar dari nilai menggunakan SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\">Jumlah nilai yang tidak sama (SUMIFS) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-sumif-atau-logika\/\">SUMIF\/SUMIFS dengan logika OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-dengan-wildcard\/\">SUMIF dengan wildcard di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-nilai-antara-dua-tanggal\/\">Rentang tanggal SUMIFS (jumlah nilai antara dua array tanggal)<\/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-1735","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 Bagaimana cara menambahkan nilai berdasarkan tanggal?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya\" \/>\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\/id\/jumlah-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan nilai berdasarkan tanggal?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan nilai berdasarkan tanggal?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\",\"datePublished\":\"2023-11-08T20:50:38+00:00\",\"dateModified\":\"2023-12-06T06:15:35+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan nilai berdasarkan tanggal?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menambahkan nilai berdasarkan tanggal?","description":"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya","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\/id\/jumlah-berdasarkan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan nilai berdasarkan tanggal?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:35+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/","name":"\u25b7 Bagaimana cara menambahkan nilai berdasarkan tanggal?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","datePublished":"2023-11-08T20:50:38+00:00","dateModified":"2023-12-06T06:15:35+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menjumlahkan nilai berdasarkan tanggal menggunakan SUMIF, dan Anda juga akan mempelajari caranya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan nilai berdasarkan tanggal?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1735"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1735\/revisions"}],"predecessor-version":[{"id":2420,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1735\/revisions\/2420"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}