Dear Mr.Winov and Mr.Kid and All..
Kenapa hasilnya gak bisa yah..ada yang salahkah pada formula yang saya
tulis?Mohon pencerahan nya yah..
Salam Hangat,Tony B
Pada Kamis, 16 April 2015 17:53, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
hmmm....
pinjam formulanya ya om
berhubung Offset termasuk kelompok fungsi yang bersifat volatile,
bagian Offset dalam formula :
=SUM(OFFSET(Q7;0;-(COLUMNS(D7:Q7)-MATCH(Q7;$D$5:$P$5;0));1;1):P7)
bisa diubah dengan Index berbunyi :
Index( d7:p7 ; MATCH(Q7;$D$5:$P$5;0) )
sehingga formula utuhnya akan berubah menjadi :
=SUM(Index( d7:p7 ; MATCH(Q7;$D$5:$P$5;0) ):P7)
*** jika regional setting komputer setempat adalah English, ganti karakter
titik koma menjadi koma
hehehe... jadi lebih pendek dikit juga.
Wassalam,
Kid
On Thu, Apr 16, 2015 at 7:07 PM, Winov X [email protected] [belajar-excel]
<[email protected]> wrote:
coba ini
=SUM(OFFSET(Q7;0;-(COLUMNS(D7:Q7)-MATCH(Q7;$D$5:$P$5;0));1;1):P7)
semoga sesuai harapan
__Winarno__
Pada Kamis, 16 April 2015 1:09, "Tony Bexcel [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pakar yang Budiman,
Adakah cara rumusan yang mudah untuk menjumlah penjualan,namun di mulai diingin
kan sesuai week yang ditentukan seperti pada contoh terlampir.Terimakasih atas
segala atensi dan support dari Pakar semua..juga temans di milis ini.
Salam sayang selalu,
Tony B
#yiv7463908227 #yiv7463908227 -- #yiv7463908227ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7463908227
#yiv7463908227ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7463908227
#yiv7463908227ygrp-mkp #yiv7463908227hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7463908227 #yiv7463908227ygrp-mkp #yiv7463908227ads
{margin-bottom:10px;}#yiv7463908227 #yiv7463908227ygrp-mkp .yiv7463908227ad
{padding:0 0;}#yiv7463908227 #yiv7463908227ygrp-mkp .yiv7463908227ad p
{margin:0;}#yiv7463908227 #yiv7463908227ygrp-mkp .yiv7463908227ad a
{color:#0000ff;text-decoration:none;}#yiv7463908227 #yiv7463908227ygrp-sponsor
#yiv7463908227ygrp-lc {font-family:Arial;}#yiv7463908227
#yiv7463908227ygrp-sponsor #yiv7463908227ygrp-lc #yiv7463908227hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7463908227
#yiv7463908227ygrp-sponsor #yiv7463908227ygrp-lc .yiv7463908227ad
{margin-bottom:10px;padding:0 0;}#yiv7463908227 #yiv7463908227actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7463908227
#yiv7463908227activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7463908227
#yiv7463908227activity span {font-weight:700;}#yiv7463908227
#yiv7463908227activity span:first-child
{text-transform:uppercase;}#yiv7463908227 #yiv7463908227activity span a
{color:#5085b6;text-decoration:none;}#yiv7463908227 #yiv7463908227activity span
span {color:#ff7900;}#yiv7463908227 #yiv7463908227activity span
.yiv7463908227underline {text-decoration:underline;}#yiv7463908227
.yiv7463908227attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7463908227 .yiv7463908227attach div a
{text-decoration:none;}#yiv7463908227 .yiv7463908227attach img
{border:none;padding-right:5px;}#yiv7463908227 .yiv7463908227attach label
{display:block;margin-bottom:5px;}#yiv7463908227 .yiv7463908227attach label a
{text-decoration:none;}#yiv7463908227 blockquote {margin:0 0 0
4px;}#yiv7463908227 .yiv7463908227bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7463908227
.yiv7463908227bold a {text-decoration:none;}#yiv7463908227 dd.yiv7463908227last
p a {font-family:Verdana;font-weight:700;}#yiv7463908227 dd.yiv7463908227last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7463908227
dd.yiv7463908227last p span.yiv7463908227yshortcuts
{margin-right:0;}#yiv7463908227 div.yiv7463908227attach-table div div a
{text-decoration:none;}#yiv7463908227 div.yiv7463908227attach-table
{width:400px;}#yiv7463908227 div.yiv7463908227file-title a, #yiv7463908227
div.yiv7463908227file-title a:active, #yiv7463908227
div.yiv7463908227file-title a:hover, #yiv7463908227 div.yiv7463908227file-title
a:visited {text-decoration:none;}#yiv7463908227 div.yiv7463908227photo-title a,
#yiv7463908227 div.yiv7463908227photo-title a:active, #yiv7463908227
div.yiv7463908227photo-title a:hover, #yiv7463908227
div.yiv7463908227photo-title a:visited {text-decoration:none;}#yiv7463908227
div#yiv7463908227ygrp-mlmsg #yiv7463908227ygrp-msg p a
span.yiv7463908227yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7463908227
.yiv7463908227green {color:#628c2a;}#yiv7463908227 .yiv7463908227MsoNormal
{margin:0 0 0 0;}#yiv7463908227 o {font-size:0;}#yiv7463908227
#yiv7463908227photos div {float:left;width:72px;}#yiv7463908227
#yiv7463908227photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7463908227
#yiv7463908227photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7463908227
#yiv7463908227reco-category {font-size:77%;}#yiv7463908227
#yiv7463908227reco-desc {font-size:77%;}#yiv7463908227 .yiv7463908227replbq
{margin:4px;}#yiv7463908227 #yiv7463908227ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7463908227 #yiv7463908227ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7463908227
#yiv7463908227ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7463908227
#yiv7463908227ygrp-mlmsg select, #yiv7463908227 input, #yiv7463908227 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7463908227
#yiv7463908227ygrp-mlmsg pre, #yiv7463908227 code {font:115%
monospace;}#yiv7463908227 #yiv7463908227ygrp-mlmsg *
{line-height:1.22em;}#yiv7463908227 #yiv7463908227ygrp-mlmsg #yiv7463908227logo
{padding-bottom:10px;}#yiv7463908227 #yiv7463908227ygrp-msg p a
{font-family:Verdana;}#yiv7463908227 #yiv7463908227ygrp-msg
p#yiv7463908227attach-count span {color:#1E66AE;font-weight:700;}#yiv7463908227
#yiv7463908227ygrp-reco #yiv7463908227reco-head
{color:#ff7900;font-weight:700;}#yiv7463908227 #yiv7463908227ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7463908227 #yiv7463908227ygrp-sponsor
#yiv7463908227ov li a {font-size:130%;text-decoration:none;}#yiv7463908227
#yiv7463908227ygrp-sponsor #yiv7463908227ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7463908227
#yiv7463908227ygrp-sponsor #yiv7463908227ov ul {margin:0;padding:0 0 0
8px;}#yiv7463908227 #yiv7463908227ygrp-text
{font-family:Georgia;}#yiv7463908227 #yiv7463908227ygrp-text p {margin:0 0 1em
0;}#yiv7463908227 #yiv7463908227ygrp-text tt {font-size:120%;}#yiv7463908227
#yiv7463908227ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7463908227
