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'
[email protected] [belajar-excel]"
<[email protected]> menulis:
Dear Mrs, Nia, See attach. Semoga sesuai harapan. Salam, DD From:
[email protected][mailto:[email protected]]
Sent: 25 Februari 2016 11:30
To: [email protected]
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:
[email protected] [mailto:[email protected]]
Sent: 25 Februari 2016 10:57
To: [email protected]
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
