makasih pak Om Mr Kid atas penyempurnaannya
tadinya mw pake index, tp rungpati mudheng + lg males mikir,jadinya geser geser
aja pake offset
he he
__Winarno__
Pada Kamis, 16 April 2015 3: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
#yiv7575246980 #yiv7575246980 -- #yiv7575246980ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7575246980
#yiv7575246980ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7575246980
#yiv7575246980ygrp-mkp #yiv7575246980hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7575246980 #yiv7575246980ygrp-mkp #yiv7575246980ads
{margin-bottom:10px;}#yiv7575246980 #yiv7575246980ygrp-mkp .yiv7575246980ad
{padding:0 0;}#yiv7575246980 #yiv7575246980ygrp-mkp .yiv7575246980ad p
{margin:0;}#yiv7575246980 #yiv7575246980ygrp-mkp .yiv7575246980ad a
{color:#0000ff;text-decoration:none;}#yiv7575246980 #yiv7575246980ygrp-sponsor
#yiv7575246980ygrp-lc {font-family:Arial;}#yiv7575246980
#yiv7575246980ygrp-sponsor #yiv7575246980ygrp-lc #yiv7575246980hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7575246980
#yiv7575246980ygrp-sponsor #yiv7575246980ygrp-lc .yiv7575246980ad
{margin-bottom:10px;padding:0 0;}#yiv7575246980 #yiv7575246980actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7575246980
#yiv7575246980activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7575246980
#yiv7575246980activity span {font-weight:700;}#yiv7575246980
#yiv7575246980activity span:first-child
{text-transform:uppercase;}#yiv7575246980 #yiv7575246980activity span a
{color:#5085b6;text-decoration:none;}#yiv7575246980 #yiv7575246980activity span
span {color:#ff7900;}#yiv7575246980 #yiv7575246980activity span
.yiv7575246980underline {text-decoration:underline;}#yiv7575246980
.yiv7575246980attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7575246980 .yiv7575246980attach div a
{text-decoration:none;}#yiv7575246980 .yiv7575246980attach img
{border:none;padding-right:5px;}#yiv7575246980 .yiv7575246980attach label
{display:block;margin-bottom:5px;}#yiv7575246980 .yiv7575246980attach label a
{text-decoration:none;}#yiv7575246980 blockquote {margin:0 0 0
4px;}#yiv7575246980 .yiv7575246980bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7575246980
.yiv7575246980bold a {text-decoration:none;}#yiv7575246980 dd.yiv7575246980last
p a {font-family:Verdana;font-weight:700;}#yiv7575246980 dd.yiv7575246980last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7575246980
dd.yiv7575246980last p span.yiv7575246980yshortcuts
{margin-right:0;}#yiv7575246980 div.yiv7575246980attach-table div div a
{text-decoration:none;}#yiv7575246980 div.yiv7575246980attach-table
{width:400px;}#yiv7575246980 div.yiv7575246980file-title a, #yiv7575246980
div.yiv7575246980file-title a:active, #yiv7575246980
div.yiv7575246980file-title a:hover, #yiv7575246980 div.yiv7575246980file-title
a:visited {text-decoration:none;}#yiv7575246980 div.yiv7575246980photo-title a,
#yiv7575246980 div.yiv7575246980photo-title a:active, #yiv7575246980
div.yiv7575246980photo-title a:hover, #yiv7575246980
div.yiv7575246980photo-title a:visited {text-decoration:none;}#yiv7575246980
div#yiv7575246980ygrp-mlmsg #yiv7575246980ygrp-msg p a
span.yiv7575246980yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7575246980
.yiv7575246980green {color:#628c2a;}#yiv7575246980 .yiv7575246980MsoNormal
{margin:0 0 0 0;}#yiv7575246980 o {font-size:0;}#yiv7575246980
#yiv7575246980photos div {float:left;width:72px;}#yiv7575246980
#yiv7575246980photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7575246980
#yiv7575246980photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7575246980
#yiv7575246980reco-category {font-size:77%;}#yiv7575246980
#yiv7575246980reco-desc {font-size:77%;}#yiv7575246980 .yiv7575246980replbq
{margin:4px;}#yiv7575246980 #yiv7575246980ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7575246980 #yiv7575246980ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7575246980
#yiv7575246980ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7575246980
#yiv7575246980ygrp-mlmsg select, #yiv7575246980 input, #yiv7575246980 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7575246980
#yiv7575246980ygrp-mlmsg pre, #yiv7575246980 code {font:115%
monospace;}#yiv7575246980 #yiv7575246980ygrp-mlmsg *
{line-height:1.22em;}#yiv7575246980 #yiv7575246980ygrp-mlmsg #yiv7575246980logo
{padding-bottom:10px;}#yiv7575246980 #yiv7575246980ygrp-msg p a
{font-family:Verdana;}#yiv7575246980 #yiv7575246980ygrp-msg
p#yiv7575246980attach-count span {color:#1E66AE;font-weight:700;}#yiv7575246980
#yiv7575246980ygrp-reco #yiv7575246980reco-head
{color:#ff7900;font-weight:700;}#yiv7575246980 #yiv7575246980ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7575246980 #yiv7575246980ygrp-sponsor
#yiv7575246980ov li a {font-size:130%;text-decoration:none;}#yiv7575246980
#yiv7575246980ygrp-sponsor #yiv7575246980ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7575246980
#yiv7575246980ygrp-sponsor #yiv7575246980ov ul {margin:0;padding:0 0 0
8px;}#yiv7575246980 #yiv7575246980ygrp-text
{font-family:Georgia;}#yiv7575246980 #yiv7575246980ygrp-text p {margin:0 0 1em
0;}#yiv7575246980 #yiv7575246980ygrp-text tt {font-size:120%;}#yiv7575246980
#yiv7575246980ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7575246980
