[belajar-excel] Membuat Laporan BOS K7a [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Membuat Laporan BOS K7a [1 Attachment]

Milis Belajar Excel mailing list
Yth para Master
mohon maaf ilmunya cetek
Belum bisa membuat Rumus dengan kriteria seperti data terlampir
Terimkasih atas bantuannya



Laporan BOS k7a.xlsx (23K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Membuat Laporan BOS K7a [1 Attachment]

Milis Belajar Excel mailing list
Mungkin kriterianya seperti  terlampir?



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Wednesday, April 26, 2017 12:27 PM
*To:* [hidden email]
*Subject:* [belajar-excel] Membuat Laporan BOS K7a [1 Attachment]





Yth para Master



mohon maaf ilmunya cetek



Belum bisa membuat Rumus dengan kriteria seperti data terlampir



Terimkasih atas bantuannya







image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
Re--Laporan BOS k7a.xlsx (21K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Membuat Laporan BOS K7a [1 Attachment]

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
apakah seperti file terlampir ?


    On Wednesday, April 26, 2017 1:02 PM, "agus setiawan [hidden email] [belajar-excel]" <[hidden email]> wrote:



     Yth para Master
mohon maaf ilmunya cetek
Belum bisa membuat Rumus dengan kriteria seperti data terlampir
Terimkasih atas bantuannya


  #yiv3579162291 #yiv3579162291 -- #yiv3579162291ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3579162291 #yiv3579162291ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3579162291 #yiv3579162291ygrp-mkp #yiv3579162291hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3579162291 #yiv3579162291ygrp-mkp #yiv3579162291ads {margin-bottom:10px;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad {padding:0 0;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad p {margin:0;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad a {color:#0000ff;text-decoration:none;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc {font-family:Arial;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc #yiv3579162291hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc .yiv3579162291ad {margin-bottom:10px;padding:0 0;}#yiv3579162291 #yiv3579162291actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3579162291 #yiv3579162291activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3579162291 #yiv3579162291activity span {font-weight:700;}#yiv3579162291 #yiv3579162291activity span:first-child {text-transform:uppercase;}#yiv3579162291 #yiv3579162291activity span a {color:#5085b6;text-decoration:none;}#yiv3579162291 #yiv3579162291activity span span {color:#ff7900;}#yiv3579162291 #yiv3579162291activity span .yiv3579162291underline {text-decoration:underline;}#yiv3579162291 .yiv3579162291attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3579162291 .yiv3579162291attach div a {text-decoration:none;}#yiv3579162291 .yiv3579162291attach img {border:none;padding-right:5px;}#yiv3579162291 .yiv3579162291attach label {display:block;margin-bottom:5px;}#yiv3579162291 .yiv3579162291attach label a {text-decoration:none;}#yiv3579162291 blockquote {margin:0 0 0 4px;}#yiv3579162291 .yiv3579162291bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3579162291 .yiv3579162291bold a {text-decoration:none;}#yiv3579162291 dd.yiv3579162291last p a {font-family:Verdana;font-weight:700;}#yiv3579162291 dd.yiv3579162291last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3579162291 dd.yiv3579162291last p span.yiv3579162291yshortcuts {margin-right:0;}#yiv3579162291 div.yiv3579162291attach-table div div a {text-decoration:none;}#yiv3579162291 div.yiv3579162291attach-table {width:400px;}#yiv3579162291 div.yiv3579162291file-title a, #yiv3579162291 div.yiv3579162291file-title a:active, #yiv3579162291 div.yiv3579162291file-title a:hover, #yiv3579162291 div.yiv3579162291file-title a:visited {text-decoration:none;}#yiv3579162291 div.yiv3579162291photo-title a, #yiv3579162291 div.yiv3579162291photo-title a:active, #yiv3579162291 div.yiv3579162291photo-title a:hover, #yiv3579162291 div.yiv3579162291photo-title a:visited {text-decoration:none;}#yiv3579162291 div#yiv3579162291ygrp-mlmsg #yiv3579162291ygrp-msg p a span.yiv3579162291yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3579162291 .yiv3579162291green {color:#628c2a;}#yiv3579162291 .yiv3579162291MsoNormal {margin:0 0 0 0;}#yiv3579162291 o {font-size:0;}#yiv3579162291 #yiv3579162291photos div {float:left;width:72px;}#yiv3579162291 #yiv3579162291photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3579162291 #yiv3579162291photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3579162291 #yiv3579162291reco-category {font-size:77%;}#yiv3579162291 #yiv3579162291reco-desc {font-size:77%;}#yiv3579162291 .yiv3579162291replbq {margin:4px;}#yiv3579162291 #yiv3579162291ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3579162291 #yiv3579162291ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3579162291 #yiv3579162291ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3579162291 #yiv3579162291ygrp-mlmsg select, #yiv3579162291 input, #yiv3579162291 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3579162291 #yiv3579162291ygrp-mlmsg pre, #yiv3579162291 code {font:115% monospace;}#yiv3579162291 #yiv3579162291ygrp-mlmsg * {line-height:1.22em;}#yiv3579162291 #yiv3579162291ygrp-mlmsg #yiv3579162291logo {padding-bottom:10px;}#yiv3579162291 #yiv3579162291ygrp-msg p a {font-family:Verdana;}#yiv3579162291 #yiv3579162291ygrp-msg p#yiv3579162291attach-count span {color:#1E66AE;font-weight:700;}#yiv3579162291 #yiv3579162291ygrp-reco #yiv3579162291reco-head {color:#ff7900;font-weight:700;}#yiv3579162291 #yiv3579162291ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov li a {font-size:130%;text-decoration:none;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov ul {margin:0;padding:0 0 0 8px;}#yiv3579162291 #yiv3579162291ygrp-text {font-family:Georgia;}#yiv3579162291 #yiv3579162291ygrp-text p {margin:0 0 1em 0;}#yiv3579162291 #yiv3579162291ygrp-text tt {font-size:120%;}#yiv3579162291 #yiv3579162291ygrp-vital ul li:last-child {border-right:none !important;}#yiv3579162291



Laporan BOS k7a - reeira.xlsx (23K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Membuat Laporan BOS K7a

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Biasanya saya menggunakan sumproduct untuk menghitung yang seperti itu,

Coba di C17 ketikkan formula sebagai berikut:

=SUMPRODUCT((LEFT(Data!$B$2:$B$26;1)*1=$A17)*(Data!$G$2:$G$26)*(Data!$C$2:$C$26=C$15))

Tarik (Copy) formula tersebut sampai ke cell L24

semoga sesuai pertanyaan.

salam



On 26/04/17 12.26, agus setiawan [hidden email]
[belajar-excel] wrote:

> Yth para Master
>
> mohon maaf ilmunya cetek
>
> Belum bisa membuat Rumus dengan kriteria seperti data terlampir
>
> Terimkasih atas bantuannya
>
>
>