Bls: Re: [belajar-excel] Mengambil data per-bulan

2018-03-28 Terurut Topik Rian Sutarsa riansuta...@yahoo.com [belajar-excel] 
makasih mas hendrik, saya akan coba



  Pada Kam, 29 Mar 2018 pada 10:43, hendrik karnadi hendrikkarn...@yahoo.com 
[belajar-excel] menulis:    

 Hai Rian,Ketik: =INDEX($C$5:$E$9,ROW()-4,MATCH($G$4,$C$4:$E$4,0))pada Sel G5, 
copy ke bawah s/d G9.
Salam,HK


On Wednesday, 28 March 2018, 5:50:59 PM GMT+7, Rian Sutarsa 
riansuta...@yahoo.com [belajar-excel]  wrote:
 
  


Assalamualaikum Wr.Wb.

Dear BeExceller mohon bantuannya mengenai formula mengambil data ke bawah 
tergantung kriteria headernya.

Untuk lebih jelasnya saya sertakan file nya.

  

Terimakasih

Wassalamualaikum Wr.Wb.
  #yiv3554452641 #yiv3554452641 -- #yiv3554452641ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3554452641 
#yiv3554452641ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3554452641 
#yiv3554452641ygrp-mkp #yiv3554452641hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3554452641 #yiv3554452641ygrp-mkp #yiv3554452641ads 
{margin-bottom:10px;}#yiv3554452641 #yiv3554452641ygrp-mkp .yiv3554452641ad 
{padding:0 0;}#yiv3554452641 #yiv3554452641ygrp-mkp .yiv3554452641ad p 
{margin:0;}#yiv3554452641 #yiv3554452641ygrp-mkp ...yiv3554452641ad a 
{color:#ff;text-decoration:none;}#yiv3554452641 #yiv3554452641ygrp-sponsor 
#yiv3554452641ygrp-lc {font-family:Arial;}#yiv3554452641 
#yiv3554452641ygrp-sponsor #yiv3554452641ygrp-lc #yiv3554452641hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3554452641 
#yiv3554452641ygrp-sponsor #yiv3554452641ygrp-lc .yiv3554452641ad 
{margin-bottom:10px;padding:0 0;}#yiv3554452641 #yiv3554452641actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3554452641 
#yiv3554452641activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3554452641
 #yiv3554452641activity span {font-weight:700;}#yiv3554452641 
#yiv3554452641activity span:first-child 
{text-transform:uppercase;}#yiv3554452641 #yiv3554452641activity span a 
{color:#5085b6;text-decoration:none;}#yiv3554452641 #yiv3554452641activity span 
span {color:#ff7900;}#yiv3554452641 #yiv3554452641activity span 
.yiv3554452641underline {text-decoration:underline;}#yiv3554452641 
.yiv3554452641attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3554452641 .yiv3554452641attach div a 
{text-decoration:none;}#yiv3554452641 ...yiv3554452641attach img 
{border:none;padding-right:5px;}#yiv3554452641 .yiv3554452641attach label 
{display:block;margin-bottom:5px;}#yiv3554452641 .yiv3554452641attach label a 
{text-decoration:none;}#yiv3554452641 blockquote {margin:0 0 0 
4px;}#yiv3554452641 .yiv3554452641bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3554452641 
.yiv3554452641bold a {text-decoration:none;}#yiv3554452641 dd.yiv3554452641last 
p a {font-family:Verdana;font-weight:700;}#yiv3554452641 dd.yiv3554452641last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3554452641 
dd.yiv3554452641last p span.yiv3554452641yshortcuts 
{margin-right:0;}#yiv3554452641 div.yiv3554452641attach-table div div a 
{text-decoration:none;}#yiv3554452641 div.yiv3554452641attach-table 
{width:400px;}#yiv3554452641 div.yiv3554452641file-title a, #yiv3554452641 
div.yiv3554452641file-title a:active, #yiv3554452641 
div.yiv3554452641file-title a:hover, #yiv3554452641 div.yiv3554452641file-title 
a:visited {text-decoration:none;}#yiv3554452641 div.yiv3554452641photo-title a, 
#yiv3554452641 div.yiv3554452641photo-title a:active, #yiv3554452641 
div.yiv3554452641photo-title a:hover, #yiv3554452641 
div.yiv3554452641photo-title a:visited {text-decoration:none;}#yiv3554452641 
div#yiv3554452641ygrp-mlmsg #yiv3554452641ygrp-msg p a 
span.yiv3554452641yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3554452641 
.yiv3554452641green {color:#628c2a;}#yiv3554452641 .yiv3554452641MsoNormal 
{margin:0 0 0 0;}#yiv3554452641 o {font-size:0;}#yiv3554452641 
#yiv3554452641photos div {float:left;width:72px;}#yiv3554452641 
#yiv3554452641photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv3554452641 
#yiv3554452641photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3554452641
 #yiv3554452641reco-category {font-size:77%;}#yiv3554452641 
#yiv3554452641reco-desc {font-size:77%;}#yiv3554452641 .yiv3554452641replbq 
{margin:4px;}#yiv3554452641 #yiv3554452641ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3554452641 #yiv3554452641ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3554452641 
#yiv3554452641ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3554452641 
#yiv3554452641ygrp-mlmsg select, #yiv3554452641 input, #yiv3554452641 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3554452641 
#yiv3554452641ygrp-mlmsg pre,

Re: [belajar-excel] mengambil data yg tidak berulang dengan beberapa kriteria

2018-03-28 Terurut Topik Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] 
waah keren Mr.Kid terima kasih, o ya saya kok ndak menemukan ribbon analyze ya?


Pada Kamis, 29 Maret 2018 01.36.28 WIB, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]  menulis:

   

Terlampir

On Wed, Mar 28, 2018 at 9:22 PM, Arif Wijaya arifw1...@yahoo...co.id 
[belajar-excel]  wrote:

  

Maaf masih bingung untuk penggunaan pivot tabel pada kasus saya ini, apa bisa 
mengambil data dari pivot tabel untuk nama yang saya inginkan ke sheet yang 
lain?


Pada Senin, 26 Maret 2018 21.37.59 WIB, Arif Wijaya arifw1...@yahoo..co.id 
[belajar-excel]  menulis: 

  
Terima kasih masukannya Mas Kid dan Mas Hendrik..


Sent from Yahoo Mail on Android

  On Mon, Mar 26, 2018 at 15:29, hendrik karnadi hendrikkarn...@yahoo.com 
[belajar-excel] wrote:    

 Hai Arif,Jika tanggal tidak perlu ditampilkan maka coba blok Range(B1:H...) 
untuk range PivotTablenya.
Salam,HK

On Monday, 26 March 2018, 2:54:14 PM GMT+7, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]  wrote:

  

Wa'alaikumussalam wr wb

Coba manfaatkan pivot table.

Oh iya,
Sebaiknya kolom tanggal ditulis lengkap disetiap baris data (tidak ada cells 
kosong di kolom tanggal)

Wassalamu'alaikum wr wb
Kid




2018-03-25 17:19 GMT+07:00 Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] 
:

   

Assalamu'alaikumsaya punya data di Sheet 1 sperti terlampir, bagaimana cara 
mengambil data dr kolom c di sheet 1 ke sheet 3 kolom  A dengan tambahan 
kriteria kolom d di sheet 1 sama seperti data B2 sheet 3. terima kasih atas 
bantuannya









  #yiv4531426899 #yiv4531426899 -- #yiv4531426899ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4531426899 
#yiv4531426899ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4531426899 
#yiv4531426899ygrp-mkp #yiv4531426899hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4531426899 #yiv4531426899ygrp-mkp #yiv4531426899ads 
{margin-bottom:10px;}#yiv4531426899 #yiv4531426899ygrp-mkp .yiv4531426899ad 
{padding:0 0;}#yiv4531426899 #yiv4531426899ygrp-mkp .yiv4531426899ad p 
{margin:0;}#yiv4531426899 #yiv4531426899ygrp-mkp .yiv4531426899ad a 
{color:#ff;text-decoration:none;}#yiv4531426899 #yiv4531426899ygrp-sponsor 
#yiv4531426899ygrp-lc {font-family:Arial;}#yiv4531426899 
#yiv4531426899ygrp-sponsor #yiv4531426899ygrp-lc #yiv4531426899hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4531426899 
#yiv4531426899ygrp-sponsor #yiv4531426899ygrp-lc .yiv4531426899ad 
{margin-bottom:10px;padding:0 0;}#yiv4531426899 #yiv4531426899actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4531426899 
#yiv4531426899activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4531426899
 #yiv4531426899activity span {font-weight:700;}#yiv4531426899 
#yiv4531426899activity span:first-child 
{text-transform:uppercase;}#yiv4531426899 #yiv4531426899activity span a 
{color:#5085b6;text-decoration:none;}#yiv4531426899 #yiv4531426899activity span 
span {color:#ff7900;}#yiv4531426899 #yiv4531426899activity span 
.yiv4531426899underline {text-decoration:underline;}#yiv4531426899 
.yiv4531426899attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4531426899 .yiv4531426899attach div a 
{text-decoration:none;}#yiv4531426899 .yiv4531426899attach img 
{border:none;padding-right:5px;}#yiv4531426899 .yiv4531426899attach label 
{display:block;margin-bottom:5px;}#yiv4531426899 .yiv4531426899attach label a 
{text-decoration:none;}#yiv4531426899 blockquote {margin:0 0 0 
4px;}#yiv4531426899 .yiv4531426899bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4531426899 
.yiv4531426899bold a {text-decoration:none;}#yiv4531426899 dd.yiv4531426899last 
p a {font-family:Verdana;font-weight:700;}#yiv4531426899 dd.yiv4531426899last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4531426899 
dd.yiv4531426899last p span.yiv4531426899yshortcuts 
{margin-right:0;}#yiv4531426899 div.yiv4531426899attach-table div div a 
{text-decoration:none;}#yiv4531426899 div.yiv4531426899attach-table 
{width:400px;}#yiv4531426899 div.yiv4531426899file-title a, #yiv4531426899 
div.yiv4531426899file-title a:active, #yiv4531426899 
div.yiv4531426899file-title a:hover, #yiv4531426899 div.yiv4531426899file-title 
a:visited {text-decoration:none;}#yiv4531426899 div.yiv4531426899photo-title a, 
#yiv4531426899 div.yiv4531426899photo-title a:active, #yiv4531426899 
div.yiv4531426899photo-title a:hover, #yiv4531426899 
div.yiv4531426899photo-title a:visited {text-decoration:none;}#yiv4531426899 
div#yiv4531426899ygrp-mlmsg #yiv4531426899ygrp-msg p a 
span...yiv4531426899yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4531426899 
.yiv4531426899green

Re: [belajar-excel] Mengambil data per-bulan

2018-03-28 Terurut Topik hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] 
 Hai Rian,Ketik: =INDEX($C$5:$E$9,ROW()-4,MATCH($G$4,$C$4:$E$4,0))pada Sel G5, 
copy ke bawah s/d G9.
Salam,HK


On Wednesday, 28 March 2018, 5:50:59 PM GMT+7, Rian Sutarsa 
riansuta...@yahoo.com [belajar-excel]  wrote:  
 
     


Assalamualaikum Wr.Wb.

Dear BeExceller mohon bantuannya mengenai formula mengambil data ke bawah 
tergantung kriteria headernya.

Untuk lebih jelasnya saya sertakan file nya.

  

Terimakasih 

Wassalamualaikum Wr.Wb.

Re: [belajar-excel] mengambil data yg tidak berulang dengan beberapa kriteria

2018-03-28 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] 
Terlampir

On Wed, Mar 28, 2018 at 9:22 PM, Arif Wijaya arifw1...@yahoo.co.id
[belajar-excel]  wrote:

>
>
> Maaf masih bingung untuk penggunaan pivot tabel pada kasus saya ini, apa
> bisa mengambil data dari pivot tabel untuk nama yang saya inginkan ke sheet
> yang lain?
>
>
> Pada Senin, 26 Maret 2018 21.37.59 WIB, Arif Wijaya arifw1...@yahoo..co.id
> [belajar-excel]  menulis:
>
>
>
>
> Terima kasih masukannya Mas Kid dan Mas Hendrik..
>
> Sent from Yahoo Mail on Android
> 
>
> On Mon, Mar 26, 2018 at 15:29, hendrik karnadi hendrikkarn...@yahoo.com
> [belajar-excel]
>  wrote:
>
>
> Hai Arif,
> Jika tanggal tidak perlu ditampilkan maka coba blok Range(B1:H...) untuk
> range PivotTablenya.
>
> Salam,
> HK
>
>
> On Monday, 26 March 2018, 2:54:14 PM GMT+7, 'Mr. Kid' mr.nm...@gmail.com
> [belajar-excel]  wrote:
>
>
>
>
> Wa'alaikumussalam wr wb
>
> Coba manfaatkan pivot table.
>
> Oh iya,
> Sebaiknya kolom tanggal ditulis lengkap disetiap baris data (tidak ada
> cells kosong di kolom tanggal)
>
> Wassalamu'alaikum wr wb
> Kid
>
>
>
>
> 2018-03-25 17:19 GMT+07:00 Arif Wijaya arifw1...@yahoo.co.id
> [belajar-excel] :
>
>
>
> Assalamu'alaikum
> saya punya data di Sheet 1 sperti terlampir, bagaimana cara mengambil data
> dr kolom c di sheet 1 ke sheet 3 kolom  A dengan tambahan kriteria kolom d
> di sheet 1 sama seperti data B2 sheet 3. terima kasih atas bantuannya
>
>
> 
>


re-PROBLEM.xlsx
Description: MS-Excel 2007 spreadsheet

Re: [belajar-excel] mengambil data yg tidak berulang dengan beberapa kriteria

2018-03-28 Terurut Topik Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] 
Maaf masih bingung untuk penggunaan pivot tabel pada kasus saya ini, apa bisa 
mengambil data dari pivot tabel untuk nama yang saya inginkan ke sheet yang 
lain?


Pada Senin, 26 Maret 2018 21.37.59 WIB, Arif Wijaya arifw1...@yahoo.co.id 
[belajar-excel]  menulis:

  
Terima kasih masukannya Mas Kid dan Mas Hendrik..


Sent from Yahoo Mail on Android

  On Mon, Mar 26, 2018 at 15:29, hendrik karnadi hendrikkarn...@yahoo.com 
[belajar-excel] wrote:    

 Hai Arif,Jika tanggal tidak perlu ditampilkan maka coba blok Range(B1:H...) 
untuk range PivotTablenya.
Salam,HK

On Monday, 26 March 2018, 2:54:14 PM GMT+7, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]  wrote:

  

Wa'alaikumussalam wr wb

Coba manfaatkan pivot table.

Oh iya,
Sebaiknya kolom tanggal ditulis lengkap disetiap baris data (tidak ada cells 
kosong di kolom tanggal)

Wassalamu'alaikum wr wb
Kid




2018-03-25 17:19 GMT+07:00 Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] 
:

  

Assalamu'alaikumsaya punya data di Sheet 1 sperti terlampir, bagaimana cara 
mengambil data dr kolom c di sheet 1 ke sheet 3 kolom  A dengan tambahan 
kriteria kolom d di sheet 1 sama seperti data B2 sheet 3. terima kasih atas 
bantuannya





  #yiv0322245111 #yiv0322245111 -- #yiv0322245111ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0322245111 
#yiv0322245111ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0322245111 
#yiv0322245111ygrp-mkp #yiv0322245111hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0322245111 #yiv0322245111ygrp-mkp #yiv0322245111ads 
{margin-bottom:10px;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad 
{padding:0 0;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad p 
{margin:0;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad a 
{color:#ff;text-decoration:none;}#yiv0322245111 #yiv0322245111ygrp-sponsor 
#yiv0322245111ygrp-lc {font-family:Arial;}#yiv0322245111 
#yiv0322245111ygrp-sponsor #yiv0322245111ygrp-lc #yiv0322245111hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0322245111 
#yiv0322245111ygrp-sponsor #yiv0322245111ygrp-lc .yiv0322245111ad 
{margin-bottom:10px;padding:0 0;}#yiv0322245111 #yiv0322245111actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0322245111 
#yiv0322245111activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0322245111
 #yiv0322245111activity span {font-weight:700;}#yiv0322245111 
#yiv0322245111activity span:first-child 
{text-transform:uppercase;}#yiv0322245111 #yiv0322245111activity span a 
{color:#5085b6;text-decoration:none;}#yiv0322245111 #yiv0322245111activity span 
span {color:#ff7900;}#yiv0322245111 #yiv0322245111activity span 
.yiv0322245111underline {text-decoration:underline;}#yiv0322245111 
.yiv0322245111attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0322245111 .yiv0322245111attach div a 
{text-decoration:none;}#yiv0322245111 .yiv0322245111attach img 
{border:none;padding-right:5px;}#yiv0322245111 .yiv0322245111attach label 
{display:block;margin-bottom:5px;}#yiv0322245111 .yiv0322245111attach label a 
{text-decoration:none;}#yiv0322245111 blockquote {margin:0 0 0 
4px;}#yiv0322245111 .yiv0322245111bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0322245111 
.yiv0322245111bold a {text-decoration:none;}#yiv0322245111 dd.yiv0322245111last 
p a {font-family:Verdana;font-weight:700;}#yiv0322245111 dd.yiv0322245111last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0322245111 
dd.yiv0322245111last p span.yiv0322245111yshortcuts 
{margin-right:0;}#yiv0322245111 div.yiv0322245111attach-table div div a 
{text-decoration:none;}#yiv0322245111 div.yiv0322245111attach-table 
{width:400px;}#yiv0322245111 div.yiv0322245111file-title a, #yiv0322245111 
div.yiv0322245111file-title a:active, #yiv0322245111 
div.yiv0322245111file-title a:hover, #yiv0322245111 div.yiv0322245111file-title 
a:visited {text-decoration:none;}#yiv0322245111 div.yiv0322245111photo-title a, 
#yiv0322245111 div.yiv0322245111photo-title a:active, #yiv0322245111 
div.yiv0322245111photo-title a:hover, #yiv0322245111 
div.yiv0322245111photo-title a:visited {text-decoration:none;}#yiv0322245111 
div#yiv0322245111ygrp-mlmsg #yiv0322245111ygrp-msg p a 
span.yiv0322245111yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0322245111 
.yiv0322245111green {color:#628c2a;}#yiv0322245111 .yiv0322245111MsoNormal 
{margin:0 0 0 0;}#yiv0322245111 o {font-size:0;}#yiv0322245111 
#yiv0322245111photos div {float:left;width:72px;}#yiv0322245111 
#yiv0322245111photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0322245111 
#yiv0322245111photos div label

[belajar-excel] Mengambil data per-bulan [1 Attachment]

2018-03-28 Terurut Topik Rian Sutarsa riansuta...@yahoo.com [belajar-excel] 
Assalamualaikum Wr.Wb.
Dear BeExceller mohon bantuannya mengenai formula mengambil data ke bawah 
tergantung kriteria headernya.
Untuk lebih jelasnya saya sertakan file nya.

Terimakasih
Wassalamualaikum Wr.Wb.


Data Penjualan.xlsx
Description: MS-Excel 2007 spreadsheet

[belajar-excel] Re: Link Antar Workbook Saat di Edit & di Hapus Akan Berubah

2018-03-28 Terurut Topik y.ron...@yahoo.com [belajar-excel] 
1. File MASTER agar terpassword biar masing2 USER tidak bisa FULL CONTROL 
apakah bisa?
 > VBA dan proteksi file (bukan proteksi workbook), maka perlu disediakan 
 > pengisian password file. Semua user yang tahu password (hanya ada 1 password 
 > untuk semua user) bisa membukanya secara langsung

 

 

 2. untuk file MASTER saat di modify maka file USER akan berubah. apakah bisa?

 > di file inputan bisa disediakan sheet berisi hasil koneksi data dengan fitur 
 > Get External Data (pastikan koneksi dalam mode readonly).

 

 untuk kedua pertanyaan dan jawaban mir kid diatas bisa dibantu secara datanya 
dong. makasih
 

 

 

 

 Regards,
 Yusuf Roni

RE: [belajar-excel] Menjumlahkan dengan banyak kriteria

2018-03-28 Terurut Topik 'CepWahyu' cepwa...@gmail.com [belajar-excel] 
It’s done!

Terimakasih banyak mr. kid…solusinya maknyu…

 

Regards

CW

 

From: belajar-excel@yahoogroups.com  
Sent: Rabu, 28 Maret 2018 03.19
To: BeExcel 
Subject: Re: [belajar-excel] Menjumlahkan dengan banyak kriteria

 

  

Terlampir SumIFs dengan 2 kolom bantu

 

2018-03-26 12:06 GMT+07:00 'CepWahyu' cepwa...@gmail.com 
  [belajar-excel]  >:

  

Dear be-exceller

 

Mohon bantuanya bagaimana menjumlahkan dengan banyak kriteria.

Contoh dan hasil yang diinginkan terlampir.

 

Best Regards

CW