{"id":1575,"date":"2023-11-16T12:50:00","date_gmt":"2023-11-16T12:50:00","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/"},"modified":"2023-12-06T06:20:25","modified_gmt":"2023-12-06T06:20:25","slug":"akun-lebih-besar-dari-nol","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/","title":{"rendered":"Menghitung nilai yang lebih besar dari nol di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3511225301\"><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 menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan fungsi COUNTIF Excel dengan menggunakan kriteria lebih besar dari nol. NB.IF adalah bagian dari <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-statistik-excel\/\">fungsi statistik<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-68886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hitungan-lebih besar dari nol-daftar-angka\" width=\"181\" height=\"404\"><\/figure><\/div><p> Di sini kami memiliki daftar angka mulai dari -10 hingga 10 dan Anda perlu menghitung angka yang lebih besar dari nol dalam daftar ini.<\/p><ol><li> Pertama, ketik \u201c=COUNTIF\u201d dan beri tanda kurung di sel C1 dimana kita akan mendapatkan hasilnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-excel-hitung-lebih besar-dari-nol-masukkan-fungsi-ke dalam sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-nombre-excel-superieur-a-zero-entrez-la-fonction-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-count-greater-than-zero-enter-function-in-cell\" width=\"414\" height=\"442\"><\/li><li> Kemudian, dalam argumen range, tentukan rentang (A2:A19) yang ingin Anda hitung jumlahnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"Rentang pilihan 3 akun Excel lebih besar dari nol\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-nombre-excel-superieur-a-zero-selectionner-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-count-greater-than-zero-select-range\" width=\"410\" height=\"476\"><\/li><li> Setelah itu, ketikkan perintah untuk berpindah ke argumen berikutnya.<\/li><li> Pada akhirnya, masukkan \u201c&gt;0\u201d dalam argumen kriteria dan tanda kurung penutup. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-excel-hitung-lebih besar dari nol-masukkan kriteria\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-excel-superieur-a-zero-entrer-des-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-count-greater-than-zero-enter-criteria\" width=\"410\" height=\"481\"><\/li><\/ol><p> Saat Anda menekan Enter, Anda akan mendapatkan hasilnya di sel C1. Dan di sini rumus ini mengembalikan hasil 11. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-68890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-excel-compte-superieur-a-zero-appuyez-sur-entrez-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hitungan-lebih besar dari nol-tekan-masuk-1\" width=\"503\" height=\"519\"><\/figure><\/div><h2 class=\"wp-block-heading\"> COUNTIFS untuk menghitung lebih besar dari nol dan kurang dari 10<\/h2><p> Dan jika Anda ingin menghitung angka yang lebih besar dari nol atau kurang dari 10 atau angka lainnya, Anda perlu menggunakan fungsi COUNTIFS. Di bawah ini rumus yang bisa Anda gunakan: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIFS(A2:A19,\"&gt;0\",A2:A19,\"&lt;10\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-68882\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-nombre-excel-superieur-a-zero-inferieur-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hitungan-lebih besar-dari-nol-kurang-dari\" width=\"442\" height=\"515\"><\/figure><\/div><p> Dalam rumus di atas, seperti yang saya katakan, Anda memiliki fungsi COUNTIFS yang memungkinkan Anda mereferensikan beberapa rentang dan menentukan beberapa kriteria. <\/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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compte-superieur-a-zero-2.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\/menghitung-antara-dua-angka\/\">Hitung antara dua angka (COUNTIFS) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/\">Hitung sel kosong (blank) menggunakan COUNTIF di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/\">Hitung sel yang kurang dari nilai tertentu (COUNTIF) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/\">Hitung sel yang tidak sama dengan di Excel (COUNTIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\">Hitung sel yang tidak kosong di Excel<\/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-1575","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 Hitung nilai yang lebih besar dari nol di Excel?<\/title>\n<meta name=\"description\" content=\"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan\" \/>\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\/akun-lebih-besar-dari-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hitung nilai yang lebih besar dari nol di Excel?\" \/>\n<meta property=\"og:description\" content=\"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.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\/akun-lebih-besar-dari-nol\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\",\"name\":\"\u25b7 Hitung nilai yang lebih besar dari nol di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png\",\"datePublished\":\"2023-11-16T12:50:00+00:00\",\"dateModified\":\"2023-12-06T06:20:25+00:00\",\"description\":\"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menghitung nilai yang lebih besar dari nol 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 Hitung nilai yang lebih besar dari nol di Excel?","description":"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan","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\/akun-lebih-besar-dari-nol\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Hitung nilai yang lebih besar dari nol di Excel?","og_description":"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.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\/akun-lebih-besar-dari-nol\/","url":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/","name":"\u25b7 Hitung nilai yang lebih besar dari nol di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png","datePublished":"2023-11-16T12:50:00+00:00","dateModified":"2023-12-06T06:20:25+00:00","description":"Untuk menghitung nilai yang lebih besar dari nol (0) dari daftar nilai atau rentang sel, Anda cukup menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-excel-superieur-a-zero-liste-de-nombres.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Menghitung nilai yang lebih besar dari nol 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\/1575","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=1575"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1575\/revisions"}],"predecessor-version":[{"id":2917,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1575\/revisions\/2917"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}