Terima kasih Pak Susilo..formula berjalan dengan baik.
On Thursday, October 6, 2016 5:01 PM, "Susilo - [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Adrian
Oo ternyata ada syaratnya lagi tohMaaf ya saya tidak konsen dengan yang itu.
Saya menggunakan sumproduct. Coba copy rumus berikut di sel
K7=SUMPRODUCT(($C$5:$C$100=I7)*($E$5:$E$100>=$I$4)*($E$5:$E$100<=$K$4)*$D$5:$D$100)
Copykan rumusnya ke bawah.
Dengan syarat : sel I4 dan K4 harus dalam format tanggal, bukan diketik bulan
begitu saja karena yang dijadikan acuan penghitungan adalah tanggal di kolom E.
Misalkan sel I7 ditulis 01/07/2016 untuk awal Juli dan sel K7 ditulis
30/09/2016 untuk akhir september.
Silakan dicoba
Terima kasihSusilo
2016-10-06 13:00 GMT+07:00 adrian piter [email protected] [belajar-excel]
<[email protected]>:
terima kasih sebelumnya pak Susilo atas perhatian dan responnya..tapi
untuk menyesuaikan dengan bulan laporan yang dipilih kayaknya masih belum bisa
pak..misalnya untuk laporan bulan Juni s.d Agustus ..siapa2 saja dan jumlah
pembayarannya berapa...terima kasih..
On Thursday, October 6, 2016 9:33 AM, "Susilo - [email protected]
[belajar-excel]" <[email protected] > wrote:
Dear Adrian
File berikut semoga bisa membantu
Terima kasihSusilo
Pada 5 Oktober 2016 10.25, adrian piter [email protected] [belajar-excel]
<[email protected] > menulis:
Dear para Master Excel,
saya mohon bantuan bagaimana membuat formula excel untuk buat laporan tentang
jumlah pembayarn dan nama-nama pembayar sesuai bulan laporan yang dipilih.
Untuk lebih jelasnya bisa dilihat di aatachment
Terima kasih atas perhatian dan bantuannya.
#yiv9016927383 #yiv9016927383 -- #yiv9016927383ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9016927383
#yiv9016927383ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9016927383
#yiv9016927383ygrp-mkp #yiv9016927383hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9016927383 #yiv9016927383ygrp-mkp #yiv9016927383ads
{margin-bottom:10px;}#yiv9016927383 #yiv9016927383ygrp-mkp .yiv9016927383ad
{padding:0 0;}#yiv9016927383 #yiv9016927383ygrp-mkp .yiv9016927383ad p
{margin:0;}#yiv9016927383 #yiv9016927383ygrp-mkp .yiv9016927383ad a
{color:#0000ff;text-decoration:none;}#yiv9016927383 #yiv9016927383ygrp-sponsor
#yiv9016927383ygrp-lc {font-family:Arial;}#yiv9016927383
#yiv9016927383ygrp-sponsor #yiv9016927383ygrp-lc #yiv9016927383hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9016927383
#yiv9016927383ygrp-sponsor #yiv9016927383ygrp-lc .yiv9016927383ad
{margin-bottom:10px;padding:0 0;}#yiv9016927383 #yiv9016927383actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9016927383
#yiv9016927383activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9016927383
#yiv9016927383activity span {font-weight:700;}#yiv9016927383
#yiv9016927383activity span:first-child
{text-transform:uppercase;}#yiv9016927383 #yiv9016927383activity span a
{color:#5085b6;text-decoration:none;}#yiv9016927383 #yiv9016927383activity span
span {color:#ff7900;}#yiv9016927383 #yiv9016927383activity span
.yiv9016927383underline {text-decoration:underline;}#yiv9016927383
.yiv9016927383attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9016927383 .yiv9016927383attach div a
{text-decoration:none;}#yiv9016927383 .yiv9016927383attach img
{border:none;padding-right:5px;}#yiv9016927383 .yiv9016927383attach label
{display:block;margin-bottom:5px;}#yiv9016927383 .yiv9016927383attach label a
{text-decoration:none;}#yiv9016927383 blockquote {margin:0 0 0
4px;}#yiv9016927383 .yiv9016927383bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9016927383
.yiv9016927383bold a {text-decoration:none;}#yiv9016927383 dd.yiv9016927383last
p a {font-family:Verdana;font-weight:700;}#yiv9016927383 dd.yiv9016927383last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9016927383
dd.yiv9016927383last p span.yiv9016927383yshortcuts
{margin-right:0;}#yiv9016927383 div.yiv9016927383attach-table div div a
{text-decoration:none;}#yiv9016927383 div.yiv9016927383attach-table
{width:400px;}#yiv9016927383 div.yiv9016927383file-title a, #yiv9016927383
div.yiv9016927383file-title a:active, #yiv9016927383
div.yiv9016927383file-title a:hover, #yiv9016927383 div.yiv9016927383file-title
a:visited {text-decoration:none;}#yiv9016927383 div.yiv9016927383photo-title a,
#yiv9016927383 div.yiv9016927383photo-title a:active, #yiv9016927383
div.yiv9016927383photo-title a:hover, #yiv9016927383
div.yiv9016927383photo-title a:visited {text-decoration:none;}#yiv9016927383
div#yiv9016927383ygrp-mlmsg #yiv9016927383ygrp-msg p a
span.yiv9016927383yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9016927383
.yiv9016927383green {color:#628c2a;}#yiv9016927383 .yiv9016927383MsoNormal
{margin:0 0 0 0;}#yiv9016927383 o {font-size:0;}#yiv9016927383
#yiv9016927383photos div {float:left;width:72px;}#yiv9016927383
#yiv9016927383photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9016927383
#yiv9016927383photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9016927383
#yiv9016927383reco-category {font-size:77%;}#yiv9016927383
#yiv9016927383reco-desc {font-size:77%;}#yiv9016927383 .yiv9016927383replbq
{margin:4px;}#yiv9016927383 #yiv9016927383ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9016927383 #yiv9016927383ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9016927383
#yiv9016927383ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9016927383
#yiv9016927383ygrp-mlmsg select, #yiv9016927383 input, #yiv9016927383 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9016927383
#yiv9016927383ygrp-mlmsg pre, #yiv9016927383 code {font:115%
monospace;}#yiv9016927383 #yiv9016927383ygrp-mlmsg *
{line-height:1.22em;}#yiv9016927383 #yiv9016927383ygrp-mlmsg #yiv9016927383logo
{padding-bottom:10px;}#yiv9016927383 #yiv9016927383ygrp-msg p a
{font-family:Verdana;}#yiv9016927383 #yiv9016927383ygrp-msg
p#yiv9016927383attach-count span {color:#1E66AE;font-weight:700;}#yiv9016927383
#yiv9016927383ygrp-reco #yiv9016927383reco-head
{color:#ff7900;font-weight:700;}#yiv9016927383 #yiv9016927383ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9016927383 #yiv9016927383ygrp-sponsor
#yiv9016927383ov li a {font-size:130%;text-decoration:none;}#yiv9016927383
#yiv9016927383ygrp-sponsor #yiv9016927383ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9016927383
#yiv9016927383ygrp-sponsor #yiv9016927383ov ul {margin:0;padding:0 0 0
8px;}#yiv9016927383 #yiv9016927383ygrp-text
{font-family:Georgia;}#yiv9016927383 #yiv9016927383ygrp-text p {margin:0 0 1em
0;}#yiv9016927383 #yiv9016927383ygrp-text tt {font-size:120%;}#yiv9016927383
#yiv9016927383ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9016927383
