{"id":3105,"date":"2023-07-19T04:51:43","date_gmt":"2023-07-19T04:51:43","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/"},"modified":"2023-07-19T04:51:43","modified_gmt":"2023-07-19T04:51:43","slug":"jumlah-excel-per-minggu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/","title":{"rendered":"Cara menambah mingguan di excel (contoh langkah-demi-langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menjumlahkan nilai kumpulan data di Excel berdasarkan minggunya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total penjualan per minggu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26491 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek1-1.jpg\" alt=\"\" width=\"419\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26491 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek1-1.jpg\" alt=\"\" width=\"419\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Ekstrak nomor minggu dari tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=WEEKNUM()<\/strong> untuk mengekstrak nomor minggu dari setiap tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=WEEKNUM( <span style=\"color: #3366ff;\">A2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26492 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek2.jpg\" alt=\"\" width=\"451\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan minggu-minggu unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=UNIQUE()<\/strong> untuk menghasilkan daftar nomor minggu yang unik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>F2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">D2:D10<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan daftar nomor minggu unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26493 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek3.jpg\" alt=\"\" width=\"531\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Temukan jumlahnya per minggu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>SUMIF(range, kriteria, sum_range)<\/strong> untuk mencari jumlah penjualan yang dilakukan setiap minggunya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>G2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">$D$2:$D$10<\/span> , <span style=\"color: #ff0000;\">F2<\/span> , <span style=\"color: #800080;\">$B$2:$B$10<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke sel yang tersisa di kolom G:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26494\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek4.jpg\" alt=\"Jumlah Excel per minggu\" width=\"554\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sebanyak <b>40<\/b> penjualan dilakukan selama minggu pertama tahun ini.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>77<\/b> penjualan dilakukan selama minggu kedua tahun ini.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>38<\/b> penjualan dilakukan selama minggu ketiga tahun ini.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan berdasarkan bulan di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan berdasarkan kategori di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-pada-beberapa-lembar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menjumlahkan nilai kumpulan data di Excel berdasarkan minggunya. Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total penjualan per minggu: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Ekstrak nomor minggu dari tanggal Selanjutnya, kita [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T04:51:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek1-1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\",\"name\":\"Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T04:51:43+00:00\",\"dateModified\":\"2023-07-19T04:51:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambah mingguan di excel (contoh langkah-demi-langkah)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial","description":"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.","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:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/","og_site_name":"Statorials","article_published_time":"2023-07-19T04:51:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sumbyweek1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/","url":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/","name":"Cara Menambahkan Mingguan di Excel (Contoh Langkah-demi-Langkah) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T04:51:43+00:00","dateModified":"2023-07-19T04:51:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan nilai per minggu di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambah mingguan di excel (contoh langkah-demi-langkah)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3105"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3105"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3105\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}