{"id":4021,"date":"2023-07-14T03:08:40","date_gmt":"2023-07-14T03:08:40","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/"},"modified":"2023-07-14T03:08:40","modified_gmt":"2023-07-14T03:08:40","slug":"jumlah-excel-per-kuartal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/","title":{"rendered":"Cara menjumlahkan per kuartal 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 kuartal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total penjualan per kuartal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32146 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete1.jpg\" alt=\"\" width=\"497\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\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-32146 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete1.jpg\" alt=\"\" width=\"501\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan kuartal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan secara manual membuat daftar empat kuartal di kolom baru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32147 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete2.jpg\" alt=\"\" width=\"482\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung jumlah per kuartal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya kita akan memasukkan rumus berikut pada sel <strong>E2<\/strong> untuk menghitung jumlah penjualan kuartal pertama:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT((ROUNDUP(MONTH( <span style=\"color: #3366ff;\">$A$2:$A$14<\/span> )\/3,0)= <span style=\"color: #ff0000;\">D2<\/span> )* <span style=\"color: #800080;\">$B$2:$B$14<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32148\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete3.jpg\" alt=\"Jumlah Excel per kuartal\" width=\"564\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Secara total, <b>71<\/b> penjualan dilakukan pada kuartal pertama.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>38<\/b> penjualan dilakukan pada kuartal kedua.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>130<\/b> penjualan dilakukan pada kuartal ketiga.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>66<\/b> penjualan dilakukan pada kuartal keempat.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenaran nilai-nilai ini dengan menghitung secara manual jumlah penjualan untuk kuartal tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya total penjualan triwulan pertama (Januari, Februari, Maret) dapat dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Penjualan kuartal pertama: 30 + 12 + 15 + 14 = <strong>71<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan rumus kami.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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-tahun\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan berdasarkan tahun di excel<\/a><br \/> <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-per-minggu\/\" target=\"_blank\" rel=\"noopener\">Cara menambah minggu di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menjumlahkan nilai kumpulan data di Excel berdasarkan kuartal. Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total penjualan per kuartal: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Masukkan kuartal Selanjutnya, kita akan secara manual [&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 Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai per kuartal 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-kuartal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai per kuartal di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T03:08:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete1.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-kuartal\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/\",\"name\":\"Cara Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T03:08:40+00:00\",\"dateModified\":\"2023-07-14T03:08:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan nilai per kuartal di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menjumlahkan per kuartal 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 Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials","description":"Tutorial ini menjelaskan cara menambahkan nilai per kuartal 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-kuartal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan nilai per kuartal di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/","og_site_name":"Statorials","article_published_time":"2023-07-14T03:08:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trimestre-dete1.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-kuartal\/","url":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/","name":"Cara Menjumlahkan Per Kuartal di Excel (Contoh Langkah-demi-Langkah) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T03:08:40+00:00","dateModified":"2023-07-14T03:08:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan nilai per kuartal di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-excel-per-kuartal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menjumlahkan per kuartal 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\/4021"}],"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=4021"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4021\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}