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:#0000ff;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 #666666;height:62px;overflow:hidden;width:62px;}#yiv0986158899 #yiv0986158899photos div label {color:#666666;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-size:inherit;font:100%;}#yiv0986158899 #yiv0986158899ygrp-mlmsg select, #yiv0986158899 input, #yiv0986158899 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0986158899 #yiv0986158899ygrp-mlmsg pre, #yiv0986158899 code {font:115% monospace;}#yiv0986158899 #yiv0986158899ygrp-mlmsg * {line-height:1.22em;}#yiv0986158899 #yiv0986158899ygrp-mlmsg #yiv0986158899logo {padding-bottom:10px;}#yiv0986158899 #yiv0986158899ygrp-msg p a {font-family:Verdana;}#yiv0986158899 #yiv0986158899ygrp-msg p#yiv0986158899attach-count span {color:#1E66AE;font-weight:700;}#yiv0986158899 #yiv0986158899ygrp-reco #yiv0986158899reco-head {color:#ff7900;font-weight:700;}#yiv0986158899 #yiv0986158899ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0986158899 #yiv0986158899ygrp-sponsor #yiv0986158899ov li a {font-size:130%;text-decoration:none;}#yiv0986158899 #yiv0986158899ygrp-sponsor #yiv0986158899ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0986158899 #yiv0986158899ygrp-sponsor #yiv0986158899ov ul {margin:0;padding:0 0 0 8px;}#yiv0986158899 #yiv0986158899ygrp-text {font-family:Georgia;}#yiv0986158899 #yiv0986158899ygrp-text p {margin:0 0 1em 0;}#yiv0986158899 #yiv0986158899ygrp-text tt {font-size:120%;}#yiv0986158899 #yiv0986158899ygrp-vital ul li:last-child {border-right:none !important;}#yiv0986158899