{"id":1616,"date":"2023-11-15T10:41:17","date_gmt":"2023-11-15T10:41:17","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/"},"modified":"2023-12-06T06:19:51","modified_gmt":"2023-12-06T06:19:51","slug":"menghitung-sel-tidak-sama-dengan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/","title":{"rendered":"Cara menghitung sel tidak sama dengan"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-919250161\"><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>Di Excel, Anda bisa menggunakan fungsi COUNTIF untuk menghitung sel yang tidak sama dengan nilai tertentu yang Anda tentukan. Anda harus menentukan rentang nilai yang akan diperiksa dan kriteria yang ingin Anda uji.<\/p><p> Pada contoh berikut Anda memiliki daftar nilai dalam bentuk angka dan sekarang dari sini Anda perlu menghitung jumlah nilai yang tidak sama dengan nol. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64242\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar nilai angka\" width=\"205\" height=\"303\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIF(A2:A15,\"&lt;&gt;0\")<\/code><\/pre><ol><li> Pertama, Anda perlu memasukkan fungsi COUNTIF di sel C1 dan memasukkan tanda kurung awal. <br><img loading=\"lazy\" decoding=\"async\" title=\"Fungsi 2-penggunaan-countif\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-la-fonction-countif.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-countif-function\" width=\"351\" height=\"285\"><\/li><li> Selanjutnya, pilih rentang yang ingin Anda hitung nilainya. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-pilih-rentang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-range\" width=\"354\" height=\"317\"><\/li><li> Setelah itu, ketikkan perintah untuk berpindah ke argumen berikutnya.<\/li><li> Terakhir, masukkan \u201c&lt;&gt;0\u201d pada kriteria dan tutup tanda kurung. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-masukkan-kriteria-dalam-hitungan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-les-criteres-dans-countif.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-criteria-in-countif\" width=\"356\" height=\"319\"><\/li><\/ol><p> Saat Anda menekan Enter, ini mengembalikan jumlah angka yang tidak sama dengan nol. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64246\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-decompte-des-nombres-non-egaux-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-angka-tidak-sama-dengan-nol\" width=\"349\" height=\"311\"><\/figure><\/div><p> Sekarang, seperti yang Anda lihat, Anda menggunakan simbol &lt;&gt; sebelum angka nol.<\/p><p> Simbol ini merupakan kombinasi tanda kurang dari dan lebih besar dari dan jika kedua tanda digunakan secara bersamaan, artinya &#8220;tidak sama&#8221;. Ada hal lain yang perlu Anda perhatikan yaitu Anda perlu mengapit kriteria dalam tanda kutip ganda. <\/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\/compter-les-cellules-non-egales-a-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-yang-tidak-kosong\/\">Hitung sel yang tidak kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\">Hitung lebih besar dari 0 (COUNTIF) 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-1616","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>Cara menghitung sel tidak sama dengan - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu 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\/menghitung-sel-tidak-sama-dengan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung sel tidak sama dengan - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.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\/menghitung-sel-tidak-sama-dengan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/\",\"name\":\"Cara menghitung sel tidak sama dengan - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png\",\"datePublished\":\"2023-11-15T10:41:17+00:00\",\"dateModified\":\"2023-12-06T06:19:51+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung sel tidak sama dengan\"}]},{\"@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":"Cara menghitung sel tidak sama dengan - Penasihat Excel","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu 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\/menghitung-sel-tidak-sama-dengan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung sel tidak sama dengan - Penasihat Excel","og_description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.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\/menghitung-sel-tidak-sama-dengan\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/","name":"Cara menghitung sel tidak sama dengan - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png","datePublished":"2023-11-15T10:41:17+00:00","dateModified":"2023-12-06T06:19:51+00:00","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menghitung sel yang tidak sama dengan nilai tertentu menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-numeriques.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung sel tidak sama dengan"}]},{"@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\/1616","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=1616"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1616\/revisions"}],"predecessor-version":[{"id":2882,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1616\/revisions\/2882"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}