sudah saya coba..maksudnya bukan jumlahnya tetapi per baristerima kasih
sebelumnya
On Friday, October 3, 2014 9:40 AM, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Bapak Topenk
apakah yang dimaksud menjumlah anggaran yang digunakan sesuai peruntukan pada
BOS?
coba gunakan rumus:
=SUMPRODUCT(($D$3:$D$22=K1)*($C$3:$C$22))
Wasalam
NangAgus
2014-10-02 11:56 GMT+07:00 Topenk Baday [email protected] [belajar-excel]
<[email protected]>:
Mohon batuannya kepada para master excelKemarin saya sudah meminta bantuan
untuk rumus excel yang masuk ke shhet yang diinginkan
sekarang saya meminta bantuan untuk bisa masuk ke kolom yang diinginkan
contoh saya lampirkan
terima kasih sebelumnya
#yiv8351040309 #yiv8351040309 -- #yiv8351040309ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8351040309
#yiv8351040309ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8351040309
#yiv8351040309ygrp-mkp #yiv8351040309hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8351040309 #yiv8351040309ygrp-mkp #yiv8351040309ads
{margin-bottom:10px;}#yiv8351040309 #yiv8351040309ygrp-mkp .yiv8351040309ad
{padding:0 0;}#yiv8351040309 #yiv8351040309ygrp-mkp .yiv8351040309ad p
{margin:0;}#yiv8351040309 #yiv8351040309ygrp-mkp .yiv8351040309ad a
{color:#0000ff;text-decoration:none;}#yiv8351040309 #yiv8351040309ygrp-sponsor
#yiv8351040309ygrp-lc {font-family:Arial;}#yiv8351040309
#yiv8351040309ygrp-sponsor #yiv8351040309ygrp-lc #yiv8351040309hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8351040309
#yiv8351040309ygrp-sponsor #yiv8351040309ygrp-lc .yiv8351040309ad
{margin-bottom:10px;padding:0 0;}#yiv8351040309 #yiv8351040309actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8351040309
#yiv8351040309activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8351040309
#yiv8351040309activity span {font-weight:700;}#yiv8351040309
#yiv8351040309activity span:first-child
{text-transform:uppercase;}#yiv8351040309 #yiv8351040309activity span a
{color:#5085b6;text-decoration:none;}#yiv8351040309 #yiv8351040309activity span
span {color:#ff7900;}#yiv8351040309 #yiv8351040309activity span
.yiv8351040309underline {text-decoration:underline;}#yiv8351040309
.yiv8351040309attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8351040309 .yiv8351040309attach div a
{text-decoration:none;}#yiv8351040309 .yiv8351040309attach img
{border:none;padding-right:5px;}#yiv8351040309 .yiv8351040309attach label
{display:block;margin-bottom:5px;}#yiv8351040309 .yiv8351040309attach label a
{text-decoration:none;}#yiv8351040309 blockquote {margin:0 0 0
4px;}#yiv8351040309 .yiv8351040309bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8351040309
.yiv8351040309bold a {text-decoration:none;}#yiv8351040309 dd.yiv8351040309last
p a {font-family:Verdana;font-weight:700;}#yiv8351040309 dd.yiv8351040309last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8351040309
dd.yiv8351040309last p span.yiv8351040309yshortcuts
{margin-right:0;}#yiv8351040309 div.yiv8351040309attach-table div div a
{text-decoration:none;}#yiv8351040309 div.yiv8351040309attach-table
{width:400px;}#yiv8351040309 div.yiv8351040309file-title a, #yiv8351040309
div.yiv8351040309file-title a:active, #yiv8351040309
div.yiv8351040309file-title a:hover, #yiv8351040309 div.yiv8351040309file-title
a:visited {text-decoration:none;}#yiv8351040309 div.yiv8351040309photo-title a,
#yiv8351040309 div.yiv8351040309photo-title a:active, #yiv8351040309
div.yiv8351040309photo-title a:hover, #yiv8351040309
div.yiv8351040309photo-title a:visited {text-decoration:none;}#yiv8351040309
div#yiv8351040309ygrp-mlmsg #yiv8351040309ygrp-msg p a
span.yiv8351040309yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8351040309
.yiv8351040309green {color:#628c2a;}#yiv8351040309 .yiv8351040309MsoNormal
{margin:0 0 0 0;}#yiv8351040309 o {font-size:0;}#yiv8351040309
#yiv8351040309photos div {float:left;width:72px;}#yiv8351040309
#yiv8351040309photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8351040309
#yiv8351040309photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8351040309
#yiv8351040309reco-category {font-size:77%;}#yiv8351040309
#yiv8351040309reco-desc {font-size:77%;}#yiv8351040309 .yiv8351040309replbq
{margin:4px;}#yiv8351040309 #yiv8351040309ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8351040309 #yiv8351040309ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8351040309
#yiv8351040309ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8351040309
#yiv8351040309ygrp-mlmsg select, #yiv8351040309 input, #yiv8351040309 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8351040309
#yiv8351040309ygrp-mlmsg pre, #yiv8351040309 code {font:115%
monospace;}#yiv8351040309 #yiv8351040309ygrp-mlmsg *
{line-height:1.22em;}#yiv8351040309 #yiv8351040309ygrp-mlmsg #yiv8351040309logo
{padding-bottom:10px;}#yiv8351040309 #yiv8351040309ygrp-msg p a
{font-family:Verdana;}#yiv8351040309 #yiv8351040309ygrp-msg
p#yiv8351040309attach-count span {color:#1E66AE;font-weight:700;}#yiv8351040309
#yiv8351040309ygrp-reco #yiv8351040309reco-head
{color:#ff7900;font-weight:700;}#yiv8351040309 #yiv8351040309ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8351040309 #yiv8351040309ygrp-sponsor
#yiv8351040309ov li a {font-size:130%;text-decoration:none;}#yiv8351040309
#yiv8351040309ygrp-sponsor #yiv8351040309ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8351040309
#yiv8351040309ygrp-sponsor #yiv8351040309ov ul {margin:0;padding:0 0 0
8px;}#yiv8351040309 #yiv8351040309ygrp-text
{font-family:Georgia;}#yiv8351040309 #yiv8351040309ygrp-text p {margin:0 0 1em
0;}#yiv8351040309 #yiv8351040309ygrp-text tt {font-size:120%;}#yiv8351040309
#yiv8351040309ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8351040309
