{"id":1682,"date":"2023-11-11T15:36:54","date_gmt":"2023-11-11T15:36:54","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/"},"modified":"2023-12-06T06:16:27","modified_gmt":"2023-12-06T06:16:27","slug":"jumlah-otomatis-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/","title":{"rendered":"Bagaimana cara menggunakan autosum di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3008693488\"><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 autosum di Excel, Anda harus memilih sel di bawah atau di sebelah kanan nilai yang ingin Anda tambahkan. Setelah Anda selesai melakukannya, Anda bisa menggunakan pintasan keyboard atau menggunakan opsi pada tab Beranda di pita. Jumlah Otomatis adalah opsi untuk menghitung dengan cepat jumlah nilai yang Anda miliki dalam suatu rentang.<\/p><h2 class=\"wp-block-heading\"> Jumlah otomatis untuk sebuah kolom<\/h2><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol><li> Pertama, pilih sel tepat di bawah sel terakhir yang memiliki nilai. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-sel-terakhir-di bawah-nilai\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"last-cell-below-values\" width=\"402\" height=\"297\"><\/li><li> Setelah itu, buka tab Beranda dan klik menu tarik-turun JumlahOtomatis. <br><img loading=\"lazy\" decoding=\"async\" title=\"Daftar drop-down jumlah otomatis 2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-liste-deroulante-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"autosum-drop-down\" width=\"476\" height=\"231\"><\/li><li> Sekarang pilih \u201cJumlah\u201d dari daftar drop-down. <br><img loading=\"lazy\" decoding=\"async\" title=\"Menu tarik-turun 3 jumlah\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-du-menu-deroulant.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-from-drop-down\" width=\"214\" height=\"252\"><\/li><li> Setelah Anda memilihnya, itu akan memasukkan fungsi penjumlahan ke dalam sel yang dipilih dengan mengacu pada rentang di atas sel. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-fungsi-jumlah-dengan-rentang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-somme-avec-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-function-with-range\" width=\"293\" height=\"352\"><\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya.<\/li><\/ol><p> Ini memberi Anda fungsi SUM yang sama dengan yang Anda masukkan secara manual ke dalam sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79233\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fonction-somme1.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi penjumlahan\" width=\"439\" height=\"384\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Jumlah otomatis untuk sebuah kolom<\/h2><p> Jika Anda ingin mendapatkan total untuk satu baris, Anda harus memilih sel di sebelah kanan nilai (di sebelah nilai terakhir). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-au-total-de-rangee.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah baris\" width=\"584\" height=\"131\"><\/figure><\/div><p> Sekarang gunakan langkah yang sama seperti yang kita gunakan untuk kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79235\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-somme-pour-les-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah untuk garis\" width=\"684\" height=\"161\"><\/figure><\/div><p> Pada akhirnya, tekan Enter untuk mendapatkan jumlahnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79236\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-appuyez-sur-entree-pour-obtenir-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"tekan enter untuk mendapatkan jumlahnya\" width=\"685\" height=\"155\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan Pintasan Keyboard untuk JumlahOtomatis<\/h2><p> Anda juga dapat menggunakan pintasan keyboard untuk penjumlahan otomatis. Yang perlu Anda lakukan hanyalah memilih sel lalu tekan pintasan keyboard Alt+=. Anda dapat mempelajarinya lebih lanjut dari halaman ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79237\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-raccourci-pour-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalan pintas untuk jumlah\" width=\"306\" height=\"142\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan autosum untuk seluruh tabel<\/h2><p> Anda juga bisa menggunakan jumlah otomatis untuk menambahkan total baris dan kolom ke tabel di Excel. Pilih sel di bawah kolom, lalu sel di sebelah kanan baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79238\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-somme-automatique-pour-toute-la-table.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah otomatis untuk seluruh tabel\" width=\"787\" height=\"344\"><\/figure><\/div><p> Lalu gunakan pintasan keyboard Alt+=, atau gunakan opsi autosum dari tab beranda. Ini akan mendapatkan total semua kolom dan baris. <\/p><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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-automatique.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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\/tambahkan-seluruh-kolom\/\">Tambahkan seluruh kolom atau baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\">Jumlahkan hanya sel yang terlihat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-sel-acak\/\">Jumlah sel acak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-keseluruhan\/\">Tambahkan baris total di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/\">TIDAK LANGSUNG dengan SUM<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/total-terakumulasi-1\/\">Jumlah kumulatif<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-kuadrat-2\/\">Jumlah kuadrat<\/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-1682","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 menggunakan autosum di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat\" \/>\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-otomatis-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan autosum di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan autosum di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\",\"datePublished\":\"2023-11-11T15:36:54+00:00\",\"dateModified\":\"2023-12-06T06:16:27+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan autosum di excel?\"}]},{\"@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 menggunakan autosum di Excel?","description":"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat","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-otomatis-1\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan autosum di Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/","name":"\u25b7 Bagaimana cara menggunakan autosum di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png","datePublished":"2023-11-11T15:36:54+00:00","dateModified":"2023-12-06T06:16:27+00:00","description":"Tutorial ini akan mengajarkan Anda cara menggunakan fungsi autosum Excel untuk mendapatkan jumlah nilai Anda dengan cepat","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan autosum di excel?"}]},{"@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\/1682","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=1682"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1682\/revisions"}],"predecessor-version":[{"id":2536,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1682\/revisions\/2536"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}