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
[email protected] [belajar-excel] <[email protected]> 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 [email protected] [belajar-excel]
Sent: Monday, August 26, 2019 10:53 AM
To: [email protected]
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
