Salam Mas Zainul benar mas di lampiran belum ada formulanya untuk length mengambil data dari sheet INPUT kolom Qjadi maksudnya rumusnya bagaimana jika menggunakan SUMIFS kalau jumlah yang ada di sheet QTY itukan gunakan rumus =REPT(1,COUNTIFS('G:\[WRR RECORD.xlsx]INPUT'!$C2:$P2,B$1)>0) nah untuk yang length apa bisa gunakan rumus terebut tapi pakau sumifs Terimakasih AssalamualaikumHairul Alam Pada Senin, 26 Agustus 2019 13.34.48 GMT+7, Zainul Ulum zainul_u...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Sebelum menjawab, Kriteria untuk menampilkan nilai LENGTH bagaiaman? Karena dalam sheet masih berupa value tidak ada formulanya. Sedangkan belum dijelaskan bagaimana cara mendapatkan nilai length. Wassalam. -zainul Sent from Mail for Windows 10 From: HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] Sent: Monday, August 26, 2019 10:53 AM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Countifs dand Sumifs [1 Attachment] Salam Mas Zainul Maaf Pada data terlampir, di sheet QTY menggunakan Rumus B2=REPT(1,COUNTIFS(INPUT!$C2:$P2,B$1)>0) dan pada sheet LENGTH bagaimana jika menggunakan Sumifs untuk hasilnya Terimakasih Assalamualaikum Hairul Alam #yiv3987821858 #yiv3987821858 -- #yiv3987821858ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3987821858 #yiv3987821858ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3987821858 #yiv3987821858ygrp-mkp #yiv3987821858hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3987821858 #yiv3987821858ygrp-mkp #yiv3987821858ads {margin-bottom:10px;}#yiv3987821858 #yiv3987821858ygrp-mkp .yiv3987821858ad {padding:0 0;}#yiv3987821858 #yiv3987821858ygrp-mkp .yiv3987821858ad p {margin:0;}#yiv3987821858 #yiv3987821858ygrp-mkp .yiv3987821858ad a {color:#0000ff;text-decoration:none;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ygrp-lc {font-family:Arial;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ygrp-lc #yiv3987821858hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ygrp-lc .yiv3987821858ad {margin-bottom:10px;padding:0 0;}#yiv3987821858 #yiv3987821858actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3987821858 #yiv3987821858activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3987821858 #yiv3987821858activity span {font-weight:700;}#yiv3987821858 #yiv3987821858activity span:first-child {text-transform:uppercase;}#yiv3987821858 #yiv3987821858activity span a {color:#5085b6;text-decoration:none;}#yiv3987821858 #yiv3987821858activity span span {color:#ff7900;}#yiv3987821858 #yiv3987821858activity span .yiv3987821858underline {text-decoration:underline;}#yiv3987821858 .yiv3987821858attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3987821858 .yiv3987821858attach div a {text-decoration:none;}#yiv3987821858 .yiv3987821858attach img {border:none;padding-right:5px;}#yiv3987821858 .yiv3987821858attach label {display:block;margin-bottom:5px;}#yiv3987821858 .yiv3987821858attach label a {text-decoration:none;}#yiv3987821858 blockquote {margin:0 0 0 4px;}#yiv3987821858 .yiv3987821858bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3987821858 .yiv3987821858bold a {text-decoration:none;}#yiv3987821858 dd.yiv3987821858last p a {font-family:Verdana;font-weight:700;}#yiv3987821858 dd.yiv3987821858last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3987821858 dd.yiv3987821858last p span.yiv3987821858yshortcuts {margin-right:0;}#yiv3987821858 div.yiv3987821858attach-table div div a {text-decoration:none;}#yiv3987821858 div.yiv3987821858attach-table {width:400px;}#yiv3987821858 div.yiv3987821858file-title a, #yiv3987821858 div.yiv3987821858file-title a:active, #yiv3987821858 div.yiv3987821858file-title a:hover, #yiv3987821858 div.yiv3987821858file-title a:visited {text-decoration:none;}#yiv3987821858 div.yiv3987821858photo-title a, #yiv3987821858 div.yiv3987821858photo-title a:active, #yiv3987821858 div.yiv3987821858photo-title a:hover, #yiv3987821858 div.yiv3987821858photo-title a:visited {text-decoration:none;}#yiv3987821858 div#yiv3987821858ygrp-mlmsg #yiv3987821858ygrp-msg p a span.yiv3987821858yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3987821858 .yiv3987821858green {color:#628c2a;}#yiv3987821858 .yiv3987821858MsoNormal {margin:0 0 0 0;}#yiv3987821858 o {font-size:0;}#yiv3987821858 #yiv3987821858photos div {float:left;width:72px;}#yiv3987821858 #yiv3987821858photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3987821858 #yiv3987821858photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3987821858 #yiv3987821858reco-category {font-size:77%;}#yiv3987821858 #yiv3987821858reco-desc {font-size:77%;}#yiv3987821858 .yiv3987821858replbq {margin:4px;}#yiv3987821858 #yiv3987821858ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3987821858 #yiv3987821858ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3987821858 #yiv3987821858ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3987821858 #yiv3987821858ygrp-mlmsg select, #yiv3987821858 input, #yiv3987821858 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3987821858 #yiv3987821858ygrp-mlmsg pre, #yiv3987821858 code {font:115% monospace;}#yiv3987821858 #yiv3987821858ygrp-mlmsg * {line-height:1.22em;}#yiv3987821858 #yiv3987821858ygrp-mlmsg #yiv3987821858logo {padding-bottom:10px;}#yiv3987821858 #yiv3987821858ygrp-msg p a {font-family:Verdana;}#yiv3987821858 #yiv3987821858ygrp-msg p#yiv3987821858attach-count span {color:#1E66AE;font-weight:700;}#yiv3987821858 #yiv3987821858ygrp-reco #yiv3987821858reco-head {color:#ff7900;font-weight:700;}#yiv3987821858 #yiv3987821858ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ov li a {font-size:130%;text-decoration:none;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3987821858 #yiv3987821858ygrp-sponsor #yiv3987821858ov ul {margin:0;padding:0 0 0 8px;}#yiv3987821858 #yiv3987821858ygrp-text {font-family:Georgia;}#yiv3987821858 #yiv3987821858ygrp-text p {margin:0 0 1em 0;}#yiv3987821858 #yiv3987821858ygrp-text tt {font-size:120%;}#yiv3987821858 #yiv3987821858ygrp-vital ul li:last-child {border-right:none !important;}#yiv3987821858