Dear Mr. Kids
Terima kasih atas solusinya dan telah memecahkan persoalan besar yang saya
alami, sekali lagi terima kasih.
Salam sukses selalu, wassalamIsmail H
Pada Rabu, 23 September 2015 0:43, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Ismail,
Fungsi Index bisa membantu dalam penyusunan rujukan range yang dinamis.
Wassalam,
Kid
2015-09-22 11:34 GMT+07:00 Ismail Hasmin ismail_has...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Dear Para Master Excel.
Saya punya permasalahan untuk ambil jumlah dari tabel lain secara otomatis
karena sifatnya berubah sesuai dasar bulan dan saya tidak tahu pakai rumus apa.
Untuk lebih jelasnya terlampir kasus dimaksud.
Atas bantuan dan solusi yang diberikan, sebelumnya saya ucapkan terima kasih.
Salam,Ismail H
#yiv0986158899 #yiv0986158899 -- #yiv0986158899ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0986158899
#yiv0986158899ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0986158899
#yiv0986158899ygrp-mkp #yiv0986158899hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0986158899 #yiv0986158899ygrp-mkp #yiv0986158899ads
{margin-bottom:10px;}#yiv0986158899 #yiv0986158899ygrp-mkp .yiv0986158899ad
{padding:0 0;}#yiv0986158899 #yiv0986158899ygrp-mkp .yiv0986158899ad p
{margin:0;}#yiv0986158899 #yiv0986158899ygrp-mkp .yiv0986158899ad a
{color:#ff;text-decoration:none;}#yiv0986158899 #yiv0986158899ygrp-sponsor
#yiv0986158899ygrp-lc {font-family:Arial;}#yiv0986158899
#yiv0986158899ygrp-sponsor #yiv0986158899ygrp-lc #yiv0986158899hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0986158899
#yiv0986158899ygrp-sponsor #yiv0986158899ygrp-lc .yiv0986158899ad
{margin-bottom:10px;padding:0 0;}#yiv0986158899 #yiv0986158899actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0986158899
#yiv0986158899activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0986158899
#yiv0986158899activity span {font-weight:700;}#yiv0986158899
#yiv0986158899activity span:first-child
{text-transform:uppercase;}#yiv0986158899 #yiv0986158899activity span a
{color:#5085b6;text-decoration:none;}#yiv0986158899 #yiv0986158899activity span
span {color:#ff7900;}#yiv0986158899 #yiv0986158899activity span
.yiv0986158899underline {text-decoration:underline;}#yiv0986158899
.yiv0986158899attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0986158899 .yiv0986158899attach div a
{text-decoration:none;}#yiv0986158899 .yiv0986158899attach img
{border:none;padding-right:5px;}#yiv0986158899 .yiv0986158899attach label
{display:block;margin-bottom:5px;}#yiv0986158899 .yiv0986158899attach label a
{text-decoration:none;}#yiv0986158899 blockquote {margin:0 0 0
4px;}#yiv0986158899 .yiv0986158899bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0986158899
.yiv0986158899bold a {text-decoration:none;}#yiv0986158899 dd.yiv0986158899last
p a {font-family:Verdana;font-weight:700;}#yiv0986158899 dd.yiv0986158899last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0986158899
dd.yiv0986158899last p span.yiv0986158899yshortcuts
{margin-right:0;}#yiv0986158899 div.yiv0986158899attach-table div div a
{text-decoration:none;}#yiv0986158899 div.yiv0986158899attach-table
{width:400px;}#yiv0986158899 div.yiv0986158899file-title a, #yiv0986158899
div.yiv0986158899file-title a:active, #yiv0986158899
div.yiv0986158899file-title a:hover, #yiv0986158899 div.yiv0986158899file-title
a:visited {text-decoration:none;}#yiv0986158899 div.yiv0986158899photo-title a,
#yiv0986158899 div.yiv0986158899photo-title a:active, #yiv0986158899
div.yiv0986158899photo-title a:hover, #yiv0986158899
div.yiv0986158899photo-title a:visited {text-decoration:none;}#yiv0986158899
div#yiv0986158899ygrp-mlmsg #yiv0986158899ygrp-msg p a
span.yiv0986158899yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0986158899
.yiv0986158899green {color:#628c2a;}#yiv0986158899 .yiv0986158899MsoNormal
{margin:0 0 0 0;}#yiv0986158899 o {font-size:0;}#yiv0986158899
#yiv0986158899photos div {float:left;width:72px;}#yiv0986158899
#yiv0986158899photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv0986158899
#yiv0986158899photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0986158899
#yiv0986158899reco-category {font-size:77%;}#yiv0986158899
#yiv0986158899reco-desc {font-size:77%;}#yiv0986158899 .yiv0986158899replbq
{margin:4px;}#yiv0986158899 #yiv0986158899ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0986158899 #yiv0986158899ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0986158899
#yiv0986158899ygrp-mlmsg table {font