saya sering mengalaminya, ga tau jg knp, moga ada master yang dapat menjelaskan, namun biasanya untuk menanganinya saya menggunakan gabungan formula indirect dan row caranya ubah bagian formula dinamis menggunakan indirect dan row() contoh pada J9 didalam sebuah tabel di masukan formula : =SUMIF($E$8:E9;E9;$I$8:I9)
maka ubahlah menjadi =SUMIF($E$8:INDIRECT("E"&ROW());E9;$I$8:INDIRECT("i"&ROW())) lakukan kepada setiap cell dalam tabel yang miliki formula yang range formula nya adalah gabungan tetap dan dinamis contoh, sum($A$1:A2) maka pada bagian A2 yang tidak ada simbol dolar $, di ganti dengan fungsi indirect & row() note : jika komputer setempat berigional english ubah karakter titik koma ";" menjadi koma "," br, odong nando Pada Kamis, 25 Februari 2016 11:56, "'Dede Sulaeman' dede_sulae...@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Dear Mrs, Nia, See attach. Semoga sesuai harapan. Salam, DD From: belajar-excel@yahoogroups.com[mailto:belajar-excel@yahoogroups.com] Sent: 25 Februari 2016 11:30 To: belajar-excel@yahoogroups.com Subject: RE: [belajar-excel] Tabel update rumus tetapi tidak sepertiatasnya Dear Mrs Nia, Coba ganti formulanya di cell L9 sepertidbi : =(LOOKUP(K9;$I$2:$I$5;$J$2:$J$5))+((J9-LOOKUP(K9;$I$2:$I$5;$H$2:$H$5))*K9)-SUMIF($E8:E$9;E9;$L8:L$9) Copas kebawah. Semoga sesuai harapan, Salam, DD From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] Sent: 25 Februari 2016 10:57 To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Tabel update rumus tetapi tidak seperti atasnya[1 Attachment] Dearall, Mautanya kalau memakai tabel kenapa rumus data di bawahnya tidak seperti atasnya,file terlampir. Mohonsolusinya, terima kasih. #yiv6044438664 #yiv6044438664 -- #yiv6044438664ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6044438664 #yiv6044438664ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6044438664 #yiv6044438664ygrp-mkp #yiv6044438664hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6044438664 #yiv6044438664ygrp-mkp #yiv6044438664ads {margin-bottom:10px;}#yiv6044438664 #yiv6044438664ygrp-mkp .yiv6044438664ad {padding:0 0;}#yiv6044438664 #yiv6044438664ygrp-mkp .yiv6044438664ad p {margin:0;}#yiv6044438664 #yiv6044438664ygrp-mkp .yiv6044438664ad a {color:#0000ff;text-decoration:none;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ygrp-lc {font-family:Arial;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ygrp-lc #yiv6044438664hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ygrp-lc .yiv6044438664ad {margin-bottom:10px;padding:0 0;}#yiv6044438664 #yiv6044438664actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6044438664 #yiv6044438664activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6044438664 #yiv6044438664activity span {font-weight:700;}#yiv6044438664 #yiv6044438664activity span:first-child {text-transform:uppercase;}#yiv6044438664 #yiv6044438664activity span a {color:#5085b6;text-decoration:none;}#yiv6044438664 #yiv6044438664activity span span {color:#ff7900;}#yiv6044438664 #yiv6044438664activity span .yiv6044438664underline {text-decoration:underline;}#yiv6044438664 .yiv6044438664attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6044438664 .yiv6044438664attach div a {text-decoration:none;}#yiv6044438664 .yiv6044438664attach img {border:none;padding-right:5px;}#yiv6044438664 .yiv6044438664attach label {display:block;margin-bottom:5px;}#yiv6044438664 .yiv6044438664attach label a {text-decoration:none;}#yiv6044438664 blockquote {margin:0 0 0 4px;}#yiv6044438664 .yiv6044438664bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6044438664 .yiv6044438664bold a {text-decoration:none;}#yiv6044438664 dd.yiv6044438664last p a {font-family:Verdana;font-weight:700;}#yiv6044438664 dd.yiv6044438664last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6044438664 dd.yiv6044438664last p span.yiv6044438664yshortcuts {margin-right:0;}#yiv6044438664 div.yiv6044438664attach-table div div a {text-decoration:none;}#yiv6044438664 div.yiv6044438664attach-table {width:400px;}#yiv6044438664 div.yiv6044438664file-title a, #yiv6044438664 div.yiv6044438664file-title a:active, #yiv6044438664 div.yiv6044438664file-title a:hover, #yiv6044438664 div.yiv6044438664file-title a:visited {text-decoration:none;}#yiv6044438664 div.yiv6044438664photo-title a, #yiv6044438664 div.yiv6044438664photo-title a:active, #yiv6044438664 div.yiv6044438664photo-title a:hover, #yiv6044438664 div.yiv6044438664photo-title a:visited {text-decoration:none;}#yiv6044438664 div#yiv6044438664ygrp-mlmsg #yiv6044438664ygrp-msg p a span.yiv6044438664yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6044438664 .yiv6044438664green {color:#628c2a;}#yiv6044438664 .yiv6044438664MsoNormal {margin:0 0 0 0;}#yiv6044438664 o {font-size:0;}#yiv6044438664 #yiv6044438664photos div {float:left;width:72px;}#yiv6044438664 #yiv6044438664photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6044438664 #yiv6044438664photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6044438664 #yiv6044438664reco-category {font-size:77%;}#yiv6044438664 #yiv6044438664reco-desc {font-size:77%;}#yiv6044438664 .yiv6044438664replbq {margin:4px;}#yiv6044438664 #yiv6044438664ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6044438664 #yiv6044438664ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6044438664 #yiv6044438664ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6044438664 #yiv6044438664ygrp-mlmsg select, #yiv6044438664 input, #yiv6044438664 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6044438664 #yiv6044438664ygrp-mlmsg pre, #yiv6044438664 code {font:115% monospace;}#yiv6044438664 #yiv6044438664ygrp-mlmsg * {line-height:1.22em;}#yiv6044438664 #yiv6044438664ygrp-mlmsg #yiv6044438664logo {padding-bottom:10px;}#yiv6044438664 #yiv6044438664ygrp-msg p a {font-family:Verdana;}#yiv6044438664 #yiv6044438664ygrp-msg p#yiv6044438664attach-count span {color:#1E66AE;font-weight:700;}#yiv6044438664 #yiv6044438664ygrp-reco #yiv6044438664reco-head {color:#ff7900;font-weight:700;}#yiv6044438664 #yiv6044438664ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ov li a {font-size:130%;text-decoration:none;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6044438664 #yiv6044438664ygrp-sponsor #yiv6044438664ov ul {margin:0;padding:0 0 0 8px;}#yiv6044438664 #yiv6044438664ygrp-text {font-family:Georgia;}#yiv6044438664 #yiv6044438664ygrp-text p {margin:0 0 1em 0;}#yiv6044438664 #yiv6044438664ygrp-text tt {font-size:120%;}#yiv6044438664 #yiv6044438664ygrp-vital ul li:last-child {border-right:none !important;}#yiv6044438664