[belajar-excel] Countifs dand Sumifs [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Countifs dand Sumifs [1 Attachment]

HAIRUL ALAM
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
TerimakasihAssalamualaikumHairul Alam


=?UTF-8?b?Q291bnRpZnMgJiBTdW1pZnMueGxzeA==?= (22K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Countifs dand Sumifs

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





AD1E4376CB4449F884FA257ED16C2733.png (194 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Countifs dand Sumifs

HAIRUL ALAM
In reply to this post by HAIRUL ALAM
 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 [hidden email] [belajar-excel] <[hidden email]> 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 [hidden email] [belajar-excel]
Sent: Monday, August 26, 2019 10:53 AM
To: [hidden email]
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
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Countifs dand Sumifs

HAIRUL ALAM
In reply to this post by HAIRUL ALAM

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

  

  



  
  #yiv2610376323 #yiv2610376323 -- #yiv2610376323ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2610376323 #yiv2610376323ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2610376323 #yiv2610376323ygrp-mkp #yiv2610376323hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2610376323 #yiv2610376323ygrp-mkp #yiv2610376323ads {margin-bottom:10px;}#yiv2610376323 #yiv2610376323ygrp-mkp .yiv2610376323ad {padding:0 0;}#yiv2610376323 #yiv2610376323ygrp-mkp .yiv2610376323ad p {margin:0;}#yiv2610376323 #yiv2610376323ygrp-mkp .yiv2610376323ad a {color:#0000ff;text-decoration:none;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ygrp-lc {font-family:Arial;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ygrp-lc #yiv2610376323hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ygrp-lc .yiv2610376323ad {margin-bottom:10px;padding:0 0;}#yiv2610376323 #yiv2610376323actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2610376323 #yiv2610376323activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2610376323 #yiv2610376323activity span {font-weight:700;}#yiv2610376323 #yiv2610376323activity span:first-child {text-transform:uppercase;}#yiv2610376323 #yiv2610376323activity span a {color:#5085b6;text-decoration:none;}#yiv2610376323 #yiv2610376323activity span span {color:#ff7900;}#yiv2610376323 #yiv2610376323activity span .yiv2610376323underline {text-decoration:underline;}#yiv2610376323 .yiv2610376323attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2610376323 .yiv2610376323attach div a {text-decoration:none;}#yiv2610376323 .yiv2610376323attach img {border:none;padding-right:5px;}#yiv2610376323 .yiv2610376323attach label {display:block;margin-bottom:5px;}#yiv2610376323 .yiv2610376323attach label a {text-decoration:none;}#yiv2610376323 blockquote {margin:0 0 0 4px;}#yiv2610376323 .yiv2610376323bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2610376323 .yiv2610376323bold a {text-decoration:none;}#yiv2610376323 dd.yiv2610376323last p a {font-family:Verdana;font-weight:700;}#yiv2610376323 dd.yiv2610376323last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2610376323 dd.yiv2610376323last p span.yiv2610376323yshortcuts {margin-right:0;}#yiv2610376323 div.yiv2610376323attach-table div div a {text-decoration:none;}#yiv2610376323 div.yiv2610376323attach-table {width:400px;}#yiv2610376323 div.yiv2610376323file-title a, #yiv2610376323 div.yiv2610376323file-title a:active, #yiv2610376323 div.yiv2610376323file-title a:hover, #yiv2610376323 div.yiv2610376323file-title a:visited {text-decoration:none;}#yiv2610376323 div.yiv2610376323photo-title a, #yiv2610376323 div.yiv2610376323photo-title a:active, #yiv2610376323 div.yiv2610376323photo-title a:hover, #yiv2610376323 div.yiv2610376323photo-title a:visited {text-decoration:none;}#yiv2610376323 div#yiv2610376323ygrp-mlmsg #yiv2610376323ygrp-msg p a span.yiv2610376323yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2610376323 .yiv2610376323green {color:#628c2a;}#yiv2610376323 .yiv2610376323MsoNormal {margin:0 0 0 0;}#yiv2610376323 o {font-size:0;}#yiv2610376323 #yiv2610376323photos div {float:left;width:72px;}#yiv2610376323 #yiv2610376323photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2610376323 #yiv2610376323photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2610376323 #yiv2610376323reco-category {font-size:77%;}#yiv2610376323 #yiv2610376323reco-desc {font-size:77%;}#yiv2610376323 .yiv2610376323replbq {margin:4px;}#yiv2610376323 #yiv2610376323ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2610376323 #yiv2610376323ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2610376323 #yiv2610376323ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2610376323 #yiv2610376323ygrp-mlmsg select, #yiv2610376323 input, #yiv2610376323 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2610376323 #yiv2610376323ygrp-mlmsg pre, #yiv2610376323 code {font:115% monospace;}#yiv2610376323 #yiv2610376323ygrp-mlmsg * {line-height:1.22em;}#yiv2610376323 #yiv2610376323ygrp-mlmsg #yiv2610376323logo {padding-bottom:10px;}#yiv2610376323 #yiv2610376323ygrp-msg p a {font-family:Verdana;}#yiv2610376323 #yiv2610376323ygrp-msg p#yiv2610376323attach-count span {color:#1E66AE;font-weight:700;}#yiv2610376323 #yiv2610376323ygrp-reco #yiv2610376323reco-head {color:#ff7900;font-weight:700;}#yiv2610376323 #yiv2610376323ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ov li a {font-size:130%;text-decoration:none;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2610376323 #yiv2610376323ygrp-sponsor #yiv2610376323ov ul {margin:0;padding:0 0 0 8px;}#yiv2610376323 #yiv2610376323ygrp-text {font-family:Georgia;}#yiv2610376323 #yiv2610376323ygrp-text p {margin:0 0 1em 0;}#yiv2610376323 #yiv2610376323ygrp-text tt {font-size:120%;}#yiv2610376323 #yiv2610376323ygrp-vital ul li:last-child {border-right:none !important;}#yiv2610376323