[belajar-excel] Menghitung banyaknya suatu nilai yang muncul [1 Attachment]

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

[belajar-excel] Menghitung banyaknya suatu nilai yang muncul [1 Attachment]

go tjwan ham
Dear Master Excel,
Mohon bantuannya untuk menghitung banyaknya suatu nilai yang muncul.Filenya terlampir.Terimakasih banyak atas bantuannya.
Regards,
Ham

Sent from Yahoo Mail on Android

mengetahui banyak nilai yang muncul.xls (10K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menghitung banyaknya suatu nilai yang muncul

hendrik karnadi
 Dear Ham,
Coba ketik Function ini:
=COUNTIF(B:B,x)
x adalah angka atau sel rujukan.
Salam,HK

    Pada Rabu, 18 September 2019 11.28.55 GMT+7, go tjwan ham [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Dear Master Excel,

Mohon bantuannya untuk menghitung banyaknya suatu nilai yang muncul.Filenya terlampir.Terimakasih banyak atas bantuannya.
Regards,
Ham

Sent from Yahoo Mail on Android    
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Menghitung banyaknya suatu nilai yang muncul

iqbal
In reply to this post by go tjwan ham
Dear Ham,

Kenapa harus rumus? Ndak manfaatkan pivot saja?

As sample





Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854







From: [hidden email] <[hidden email]>
Sent: Wednesday, September 18, 2019 11:09 AM
To: [hidden email]
Subject: [belajar-excel] Menghitung banyaknya suatu nilai yang muncul [1 Attachment]





Dear Master Excel,



Mohon bantuannya untuk menghitung banyaknya suatu nilai yang muncul.

Filenya terlampir.

Terimakasih banyak atas bantuannya.



Regards,



Ham

Sent from Yahoo Mail on Android <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>




mengetahui banyak nilai yang muncul.xls (33K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Menghitung banyaknya suatu nilai yang muncul

go tjwan ham
Thanks Mr Hendrik & Mr.Iqbal buat bantuannya.
Regards, 
Ham

Sent from Yahoo Mail on Android

  On Wed, Sep 18, 2019 at 14:48, iq_bal76id@yahoo...com [belajar-excel]<[hidden email]> wrote:    


Dear Ham,

Kenapa harus rumus? Ndak manfaatkan pivot saja?

As sample

  

  

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

  

  

  

From: [hidden email] <[hidden email]>
Sent: Wednesday, September 18, 2019 11:09 AM
To: [hidden email]
Subject: [belajar-excel] Menghitung banyaknya suatu nilai yang muncul [1 Attachment]

  

 

Dear Master Excel,

  

Mohon bantuannya untuk menghitung banyaknya suatu nilai yang muncul.

Filenya terlampir.

Terimakasih banyak atas bantuannya.

  

Regards,

  

Ham

Sent from Yahoo Mail on Android


  #yiv3233269105 #yiv3233269105 -- #yiv3233269105ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3233269105 #yiv3233269105ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3233269105 #yiv3233269105ygrp-mkp #yiv3233269105hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3233269105 #yiv3233269105ygrp-mkp #yiv3233269105ads {margin-bottom:10px;}#yiv3233269105 #yiv3233269105ygrp-mkp .yiv3233269105ad {padding:0 0;}#yiv3233269105 #yiv3233269105ygrp-mkp .yiv3233269105ad p {margin:0;}#yiv3233269105 #yiv3233269105ygrp-mkp .yiv3233269105ad a {color:#0000ff;text-decoration:none;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ygrp-lc {font-family:Arial;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ygrp-lc #yiv3233269105hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ygrp-lc .yiv3233269105ad {margin-bottom:10px;padding:0 0;}#yiv3233269105 #yiv3233269105actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3233269105 #yiv3233269105activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3233269105 #yiv3233269105activity span {font-weight:700;}#yiv3233269105 #yiv3233269105activity span:first-child {text-transform:uppercase;}#yiv3233269105 #yiv3233269105activity span a {color:#5085b6;text-decoration:none;}#yiv3233269105 #yiv3233269105activity span span {color:#ff7900;}#yiv3233269105 #yiv3233269105activity span .yiv3233269105underline {text-decoration:underline;}#yiv3233269105 ...yiv3233269105attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3233269105 .yiv3233269105attach div a {text-decoration:none;}#yiv3233269105 .yiv3233269105attach img {border:none;padding-right:5px;}#yiv3233269105 .yiv3233269105attach label {display:block;margin-bottom:5px;}#yiv3233269105 .yiv3233269105attach label a {text-decoration:none;}#yiv3233269105 blockquote {margin:0 0 0 4px;}#yiv3233269105 .yiv3233269105bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3233269105 .yiv3233269105bold a {text-decoration:none;}#yiv3233269105 dd.yiv3233269105last p a {font-family:Verdana;font-weight:700;}#yiv3233269105 dd.yiv3233269105last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3233269105 dd.yiv3233269105last p span.yiv3233269105yshortcuts {margin-right:0;}#yiv3233269105 div.yiv3233269105attach-table div div a {text-decoration:none;}#yiv3233269105 div.yiv3233269105attach-table {width:400px;}#yiv3233269105 div.yiv3233269105file-title a, #yiv3233269105 div.yiv3233269105file-title a:active, #yiv3233269105 div.yiv3233269105file-title a:hover, #yiv3233269105 div.yiv3233269105file-title a:visited {text-decoration:none;}#yiv3233269105 div.yiv3233269105photo-title a, #yiv3233269105 div.yiv3233269105photo-title a:active, #yiv3233269105 div.yiv3233269105photo-title a:hover, #yiv3233269105 div.yiv3233269105photo-title a:visited {text-decoration:none;}#yiv3233269105 div#yiv3233269105ygrp-mlmsg #yiv3233269105ygrp-msg p a span.yiv3233269105yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3233269105 .yiv3233269105green {color:#628c2a;}#yiv3233269105 .yiv3233269105MsoNormal {margin:0 0 0 0;}#yiv3233269105 o {font-size:0;}#yiv3233269105 #yiv3233269105photos div {float:left;width:72px;}#yiv3233269105 #yiv3233269105photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3233269105 #yiv3233269105photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3233269105 #yiv3233269105reco-category {font-size:77%;}#yiv3233269105 #yiv3233269105reco-desc {font-size:77%;}#yiv3233269105 .yiv3233269105replbq {margin:4px;}#yiv3233269105 #yiv3233269105ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3233269105 #yiv3233269105ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3233269105 #yiv3233269105ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3233269105 #yiv3233269105ygrp-mlmsg select, #yiv3233269105 input, #yiv3233269105 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3233269105 #yiv3233269105ygrp-mlmsg pre, #yiv3233269105 code {font:115% monospace;}#yiv3233269105 #yiv3233269105ygrp-mlmsg * {line-height:1.22em;}#yiv3233269105 #yiv3233269105ygrp-mlmsg #yiv3233269105logo {padding-bottom:10px;}#yiv3233269105 #yiv3233269105ygrp-msg p a {font-family:Verdana;}#yiv3233269105 #yiv3233269105ygrp-msg p#yiv3233269105attach-count span {color:#1E66AE;font-weight:700;}#yiv3233269105 #yiv3233269105ygrp-reco #yiv3233269105reco-head {color:#ff7900;font-weight:700;}#yiv3233269105 #yiv3233269105ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ov li a {font-size:130%;text-decoration:none;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3233269105 #yiv3233269105ygrp-sponsor #yiv3233269105ov ul {margin:0;padding:0 0 0 8px;}#yiv3233269105 #yiv3233269105ygrp-text {font-family:Georgia;}#yiv3233269105 #yiv3233269105ygrp-text p {margin:0 0 1em 0;}#yiv3233269105 #yiv3233269105ygrp-text tt {font-size:120%;}#yiv3233269105 #yiv3233269105ygrp-vital ul li:last-child {border-right:none !important;}#yiv3233269105