Waalaikumsalam Pak Hery
terima kasih koreksinya, betul jika kolom remark tidak blank heeee
arti simbol "<"&">"" itu apa ya?ko petik paling belakang ada 2
mohon dijelaskan bahasa manusianya, biar ngga gagal paham
terima kasih
wassalamualaikum
pie
Pada Kamis, 24 Januari 2019 09.49.06 WIB, Ghery Yen [email protected]
[belajar-excel] <[email protected]> menulis:
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Pertanyaan :
Mohon bantuan master excel, bagaimana menghitung jumlah data di J2,
jika kolom kolom I adalah tanggal yang dimaksud, kolom J1 adalah MP maka kolom
J2 akan terisi 4
Begitu selanjutnya untuk BP, WH, S, IDL
Sepertinya ada yang kurang deh mba, mungkin lupa ditulis
kalau Remark nya tidak Blank gitu ya ?! Berikut tanggapannya ...
terima kasih sebelumnya
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
On Wed, 23 Jan 2019 at 15:42, indria pie [email protected] [belajar-excel]
<[email protected]> wrote:
salam excel
mohon bantuan master-master excel, untuk persoalan kami (terlampir)
terima kasih sebelumnya
salam,pie
#yiv4937556255 #yiv4937556255 -- #yiv4937556255ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4937556255
#yiv4937556255ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4937556255
#yiv4937556255ygrp-mkp #yiv4937556255hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4937556255 #yiv4937556255ygrp-mkp #yiv4937556255ads
{margin-bottom:10px;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad
{padding:0 0;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad p
{margin:0;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad a
{color:#0000ff;text-decoration:none;}#yiv4937556255 #yiv4937556255ygrp-sponsor
#yiv4937556255ygrp-lc {font-family:Arial;}#yiv4937556255
#yiv4937556255ygrp-sponsor #yiv4937556255ygrp-lc #yiv4937556255hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4937556255
#yiv4937556255ygrp-sponsor #yiv4937556255ygrp-lc .yiv4937556255ad
{margin-bottom:10px;padding:0 0;}#yiv4937556255 #yiv4937556255actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4937556255
#yiv4937556255activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4937556255
#yiv4937556255activity span {font-weight:700;}#yiv4937556255
#yiv4937556255activity span:first-child
{text-transform:uppercase;}#yiv4937556255 #yiv4937556255activity span a
{color:#5085b6;text-decoration:none;}#yiv4937556255 #yiv4937556255activity span
span {color:#ff7900;}#yiv4937556255 #yiv4937556255activity span
.yiv4937556255underline {text-decoration:underline;}#yiv4937556255
.yiv4937556255attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4937556255 .yiv4937556255attach div a
{text-decoration:none;}#yiv4937556255 .yiv4937556255attach img
{border:none;padding-right:5px;}#yiv4937556255 .yiv4937556255attach label
{display:block;margin-bottom:5px;}#yiv4937556255 .yiv4937556255attach label a
{text-decoration:none;}#yiv4937556255 blockquote {margin:0 0 0
4px;}#yiv4937556255 .yiv4937556255bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4937556255
.yiv4937556255bold a {text-decoration:none;}#yiv4937556255 dd.yiv4937556255last
p a {font-family:Verdana;font-weight:700;}#yiv4937556255 dd.yiv4937556255last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4937556255
dd.yiv4937556255last p span.yiv4937556255yshortcuts
{margin-right:0;}#yiv4937556255 div.yiv4937556255attach-table div div a
{text-decoration:none;}#yiv4937556255 div.yiv4937556255attach-table
{width:400px;}#yiv4937556255 div.yiv4937556255file-title a, #yiv4937556255
div.yiv4937556255file-title a:active, #yiv4937556255
div.yiv4937556255file-title a:hover, #yiv4937556255 div.yiv4937556255file-title
a:visited {text-decoration:none;}#yiv4937556255 div.yiv4937556255photo-title a,
#yiv4937556255 div.yiv4937556255photo-title a:active, #yiv4937556255
div.yiv4937556255photo-title a:hover, #yiv4937556255
div.yiv4937556255photo-title a:visited {text-decoration:none;}#yiv4937556255
div#yiv4937556255ygrp-mlmsg #yiv4937556255ygrp-msg p a
span.yiv4937556255yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4937556255
.yiv4937556255green {color:#628c2a;}#yiv4937556255 .yiv4937556255MsoNormal
{margin:0 0 0 0;}#yiv4937556255 o {font-size:0;}#yiv4937556255
#yiv4937556255photos div {float:left;width:72px;}#yiv4937556255
#yiv4937556255photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4937556255
#yiv4937556255photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4937556255
#yiv4937556255reco-category {font-size:77%;}#yiv4937556255
#yiv4937556255reco-desc {font-size:77%;}#yiv4937556255 .yiv4937556255replbq
{margin:4px;}#yiv4937556255 #yiv4937556255ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4937556255 #yiv4937556255ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4937556255
#yiv4937556255ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4937556255
#yiv4937556255ygrp-mlmsg select, #yiv4937556255 input, #yiv4937556255 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4937556255
#yiv4937556255ygrp-mlmsg pre, #yiv4937556255 code {font:115%
monospace;}#yiv4937556255 #yiv4937556255ygrp-mlmsg *
{line-height:1.22em;}#yiv4937556255 #yiv4937556255ygrp-mlmsg #yiv4937556255logo
{padding-bottom:10px;}#yiv4937556255 #yiv4937556255ygrp-msg p a
{font-family:Verdana;}#yiv4937556255 #yiv4937556255ygrp-msg
p#yiv4937556255attach-count span {color:#1E66AE;font-weight:700;}#yiv4937556255
#yiv4937556255ygrp-reco #yiv4937556255reco-head
{color:#ff7900;font-weight:700;}#yiv4937556255 #yiv4937556255ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4937556255 #yiv4937556255ygrp-sponsor
#yiv4937556255ov li a {font-size:130%;text-decoration:none;}#yiv4937556255
#yiv4937556255ygrp-sponsor #yiv4937556255ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4937556255
#yiv4937556255ygrp-sponsor #yiv4937556255ov ul {margin:0;padding:0 0 0
8px;}#yiv4937556255 #yiv4937556255ygrp-text
{font-family:Georgia;}#yiv4937556255 #yiv4937556255ygrp-text p {margin:0 0 1em
0;}#yiv4937556255 #yiv4937556255ygrp-text tt {font-size:120%;}#yiv4937556255
#yiv4937556255ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4937556255
