{"id":2321,"date":"2023-07-22T19:02:03","date_gmt":"2023-07-22T19:02:03","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/"},"modified":"2023-07-22T19:02:03","modified_gmt":"2023-07-22T19:02:03","slug":"jumlah-kueri-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan fungsi sum"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi SUM()<\/b> dalam kueri Google Spreadsheet untuk menemukan jumlah nilai dalam baris yang memenuhi kondisi tertentu.<\/span><\/p>\n

Metode 1: Tambahkan semua baris<\/span><\/strong><\/p>\n

 =<\/span> QUERY<\/span> (<\/span> A1:C13<\/span> ,<\/span> \" select sum(C)<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Metode 2: Tambahkan baris yang memenuhi kriteria<\/span><\/strong><\/p>\n
 =<\/span> QUERY<\/span> (<\/span> A1:C13<\/span> ,<\/span> \" select sum(C) where B>100<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Metode 3: Tambahkan baris yang memenuhi beberapa kriteria<\/span><\/strong><\/p>\n
 =<\/span> QUERY<\/span> (<\/span> A1:C13<\/span> ,<\/span> \" select sum(C) where A='Mavs' OR B>100<\/span> \"<\/span> )\n\n=QUERY( A1:C13<\/span><\/span> , \" select sum(C) where A='Mavs' AND B>100<\/span> \"<\/span> )<\/span>\n<\/span><\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n
 Metode 1: Tambahkan semua baris<\/span><\/strong><\/h2>\n
 Kita dapat menggunakan rumus berikut untuk menjumlahkan total poin yang dicetak oleh semua tim:<\/span> <\/p>\n
\"\"<\/p>\n
 Kami melihat bahwa tim mencetak total 1.141<\/strong> poin.<\/span><\/p>\n
 Contoh 2: tambahkan baris yang memenuhi kriteria<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan rumus berikut untuk menjumlahkan total poin yang dicetak oleh tim yang melakukan kurang dari 30 rebound:<\/span> <\/p>\n
\"\"<\/p>\n
 Total poin yang dicetak oleh tim dengan kurang dari 30 rebound adalah 679<\/strong> .<\/span><\/p>\n
 Contoh 3:<\/strong><\/span> Tambahkan baris yang memenuhi beberapa kriteria<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan rumus berikut untuk menjumlahkan total rebound oleh tim yang nama timnya sama dengan “Mavs” atau yang total poinnya lebih besar dari 100:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah rebound di antara tim yang memenuhi salah satu kriteria ini adalah 84<\/strong> .<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya dengan kueri Google Spreadsheet:<\/span><\/p>\n
 Kueri Google Spreadsheet: pilih baris yang berisi string<\/a>
 Kueri Google Spreadsheet: cara menggunakan grup menurut<\/a>
 Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan<\/a>
 Kueri Google Spreadsheet: cara menggunakan fungsi COUNT<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi SUM() dalam kueri Google Spreadsheet untuk menemukan jumlah nilai dalam baris yang memenuhi kondisi tertentu. Metode 1: Tambahkan semua baris = QUERY ( A1:C13 , ” select sum(C) ” ) Metode 2: Tambahkan baris yang memenuhi kriteria = QUERY ( A1:C13 , ” select sum(C) where B>100 ” ) Metode 3: […]<\/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":"\nKueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.\" \/>\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-kueri-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:02:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme11.png\" \/>\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-kueri-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/\",\"name\":\"Kueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:02:03+00:00\",\"dateModified\":\"2023-07-22T19:02:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan fungsi sum\"}]},{\"@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":"Kueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.","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-kueri-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:02:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme11.png"}],"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-kueri-google-sheets\/","url":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/","name":"Kueri Google Spreadsheet: Cara menggunakan fungsi SUM - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:02:03+00:00","dateModified":"2023-07-22T19:02:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SUM() di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-kueri-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan fungsi sum"}]},{"@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\/2321"}],"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=2321"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2321\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}