{"id":1555,"date":"2023-11-17T07:39:08","date_gmt":"2023-11-17T07:39:08","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/"},"modified":"2023-12-06T06:17:58","modified_gmt":"2023-12-06T06:17:58","slug":"hitung-jika-kurang-dari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/","title":{"rendered":"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2258070215\"><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, jika Anda ingin menghitung sel yang nilainya kurang dari atau di bawah nilai tertentu, Anda perlu menggunakan fungsi COUNTIF. Dengan fungsi ini, Anda dapat menentukan rentang nilai yang akan dihitung, lalu sejumlah kriteria untuk menghitung sel di bawahnya.<\/p><p> Dalam tutorial rumus ini, kita akan melihat beberapa contoh untuk memahaminya.<\/p><h2 class=\"wp-block-heading\"> COUNTIF untuk menghitung lebih sedikit sel<\/h2><p> Pada contoh berikut, kita memiliki daftar nilai di kolom (daftar 1000 angka). Sekarang Anda perlu menghitung sel yang kurang dari 45. Seperti yang saya katakan, Anda perlu menggunakan COUNTIF, kami akan menulis rumus ini di sel B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67115\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar nilai\" width=\"357\" height=\"395\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama, mulailah mengetikkan fungsi COUNTIF di sel B1 (Enter =COUNTIF).<\/li><li> Setelah itu, pada argumen pertama fungsi tersebut, lihat kolom A, Anda juga bisa merujuk ke A1:A101 saja.<\/li><li> Sekarang ketikkan koma dan masukkan argumen kedua.<\/li><li> Dari sana Anda perlu menentukan argumen untuk kriteria tersebut. Jadi, ketik &lt;=45 dengan tanda kutip ganda.<\/li><li> Terakhir, ketikkan tanda kurung penutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67116\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-countif-fonction-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"countif-fungsi-digunakan\" width=\"413\" height=\"344\"><\/figure><\/div><p> Dan setelah Anda menekan Enter, ini mengembalikan jumlah sel dengan nilai kurang dari atau sama dengan 46. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67117\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-nombre-de-valeurs-selon-les-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah nilai-sesuai-kriteria\" width=\"462\" height=\"323\"><\/figure><\/div><p> Anda juga dapat menentukan sel yang berisi nilai kriteria. Dalam contoh berikut, Anda memiliki nilai di sel B1 yang ingin Anda gunakan sebagai kriteria, lalu mereferensikan sel dalam fungsi tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67118\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-countif-avec-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"akun dengan kriteria\" width=\"472\" height=\"287\"><\/figure><\/div><p> Sekarang, jika Anda lihat, kita memiliki rumusnya di sel B4. Sekarang dalam rumus ini kita mengacu pada rentang A1:A101.<\/p><p> Dan pada argumen kedua, di mana kita perlu menentukan kriterianya, kita telah memasukkan operator yang lebih besar dan sama dengan menggunakan tanda kutip ganda.<\/p><p> Setelah itu, kami menggunakan ampersand dan merujuk ke sel B1.<\/p><p> Dengan begitu, jika ingin mengubah kriterianya, Anda tidak perlu mengubah nilai rumusnya sendiri, Anda bisa mengubahnya dari sel B1.<\/p><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><ol type=\"1\"><li> Saat Anda menggunakan &lt;=, Excel memperlakukannya sebagai kurang dari dan sama dengan. Jadi jika menggunakan &lt;= 45 berarti semua nilainya kurang dari 45. Namun jika hanya menggunakan &lt; berarti hanya mengacu pada nilai yang kurang dari saja, misal &lt;45 berarti nilainya kurang dari 45.<\/li><li> Anda juga dapat membuat beberapa kriteria menggunakan fungsi COUNTIFS dan selain itu Anda dapat menggunakan COUNTIF OR di Excel untuk membuat logika atau sambil menghitung nilai yang kurang dari. <\/li><\/ol><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-si-moins-de-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\/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><li> <a href=\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\">Hitung lebih besar dari 0 (COUNTIF) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/countives-countif-atau-logis\/\">ATAU Logika dalam COUNTIF\/COUNIFS 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-1555","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>Bagaimana cara menghitung sel yang kurang dari nilai tertentu?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah\" \/>\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\/hitung-jika-kurang-dari\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-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\/hitung-jika-kurang-dari\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/\",\"name\":\"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"datePublished\":\"2023-11-17T07:39:08+00:00\",\"dateModified\":\"2023-12-06T06:17:58+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?\"}]},{\"@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":"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah","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\/hitung-jika-kurang-dari\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah","og_url":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-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\/hitung-jika-kurang-dari\/","url":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/","name":"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","datePublished":"2023-11-17T07:39:08+00:00","dateModified":"2023-12-06T06:17:58+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus mudah","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung sel yang kurang dari nilai tertentu?"}]},{"@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\/1555","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=1555"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1555\/revisions"}],"predecessor-version":[{"id":2666,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1555\/revisions\/2666"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}