yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa
harus pakai waktu 5 bulan ya..?
br,
odong nando
Dari: "'Fendik Anton Wijaya' [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1
Attachment]
Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika
harus menggunakan formula countif bertingkat tapi dengan kriteria yg
berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria
bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa
uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya
jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7
hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan
maret - juli. Atas bantuannya saya ucapkan Terima Kasih Banyak.Semoga Amal dan
ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...Sekali lagi terima
kasih banyak atas bantuannya... Best regards,
Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550
The information transmitted is intended only for the person or the entity to
which it is addressed and may contain confidential and/or privileged material.
If you have received it by mistake please notify the sender by return e-mail
and delete this message including any of its attachments from your system. Any
use, review, reliance or dissemination of this message/information in whole or
in part is strictly prohibited. Please note that e-mails are susceptible to
change. The views expressed/presented in this email are solely those of the
author and do not necessarily represent those of PT Toyota Astra Financial
Services and should not be construed as the views, offers or acceptances of PT
Toyota Astra Financial Services. The recipient should check this email/message
and any attachments for the presence of viruses. PT Toyota Astra Financial
Services accepts no liability for any damage caused by any viruses transmitted
by this email/message.
ýTowards a Sustainable Future - Please consider the environment before printing
this email.
#yiv1640187844 #yiv1640187844 -- #yiv1640187844ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1640187844
#yiv1640187844ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1640187844
#yiv1640187844ygrp-mkp #yiv1640187844hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1640187844 #yiv1640187844ygrp-mkp #yiv1640187844ads
{margin-bottom:10px;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad
{padding:0 0;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad p
{margin:0;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad a
{color:#0000ff;text-decoration:none;}#yiv1640187844 #yiv1640187844ygrp-sponsor
#yiv1640187844ygrp-lc {font-family:Arial;}#yiv1640187844
#yiv1640187844ygrp-sponsor #yiv1640187844ygrp-lc #yiv1640187844hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1640187844
#yiv1640187844ygrp-sponsor #yiv1640187844ygrp-lc .yiv1640187844ad
{margin-bottom:10px;padding:0 0;}#yiv1640187844 #yiv1640187844actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1640187844
#yiv1640187844activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1640187844
#yiv1640187844activity span {font-weight:700;}#yiv1640187844
#yiv1640187844activity span:first-child
{text-transform:uppercase;}#yiv1640187844 #yiv1640187844activity span a
{color:#5085b6;text-decoration:none;}#yiv1640187844 #yiv1640187844activity span
span {color:#ff7900;}#yiv1640187844 #yiv1640187844activity span
.yiv1640187844underline {text-decoration:underline;}#yiv1640187844
.yiv1640187844attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1640187844 .yiv1640187844attach div a
{text-decoration:none;}#yiv1640187844 .yiv1640187844attach img
{border:none;padding-right:5px;}#yiv1640187844 .yiv1640187844attach label
{display:block;margin-bottom:5px;}#yiv1640187844 .yiv1640187844attach label a
{text-decoration:none;}#yiv1640187844 blockquote {margin:0 0 0
4px;}#yiv1640187844 .yiv1640187844bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1640187844
.yiv1640187844bold a {text-decoration:none;}#yiv1640187844 dd.yiv1640187844last
p a {font-family:Verdana;font-weight:700;}#yiv1640187844 dd.yiv1640187844last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1640187844
dd.yiv1640187844last p span.yiv1640187844yshortcuts
{margin-right:0;}#yiv1640187844 div.yiv1640187844attach-table div div a
{text-decoration:none;}#yiv1640187844 div.yiv1640187844attach-table
{width:400px;}#yiv1640187844 div.yiv1640187844file-title a, #yiv1640187844
div.yiv1640187844file-title a:active, #yiv1640187844
div.yiv1640187844file-title a:hover, #yiv1640187844 div.yiv1640187844file-title
a:visited {text-decoration:none;}#yiv1640187844 div.yiv1640187844photo-title a,
#yiv1640187844 div.yiv1640187844photo-title a:active, #yiv1640187844
div.yiv1640187844photo-title a:hover, #yiv1640187844
div.yiv1640187844photo-title a:visited {text-decoration:none;}#yiv1640187844
div#yiv1640187844ygrp-mlmsg #yiv1640187844ygrp-msg p a
span.yiv1640187844yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1640187844
.yiv1640187844green {color:#628c2a;}#yiv1640187844 .yiv1640187844MsoNormal
{margin:0 0 0 0;}#yiv1640187844 o {font-size:0;}#yiv1640187844
#yiv1640187844photos div {float:left;width:72px;}#yiv1640187844
#yiv1640187844photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1640187844
#yiv1640187844photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1640187844
#yiv1640187844reco-category {font-size:77%;}#yiv1640187844
#yiv1640187844reco-desc {font-size:77%;}#yiv1640187844 .yiv1640187844replbq
{margin:4px;}#yiv1640187844 #yiv1640187844ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1640187844 #yiv1640187844ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1640187844
#yiv1640187844ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1640187844
#yiv1640187844ygrp-mlmsg select, #yiv1640187844 input, #yiv1640187844 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1640187844
#yiv1640187844ygrp-mlmsg pre, #yiv1640187844 code {font:115%
monospace;}#yiv1640187844 #yiv1640187844ygrp-mlmsg *
{line-height:1.22em;}#yiv1640187844 #yiv1640187844ygrp-mlmsg #yiv1640187844logo
{padding-bottom:10px;}#yiv1640187844 #yiv1640187844ygrp-msg p a
{font-family:Verdana;}#yiv1640187844 #yiv1640187844ygrp-msg
p#yiv1640187844attach-count span {color:#1E66AE;font-weight:700;}#yiv1640187844
#yiv1640187844ygrp-reco #yiv1640187844reco-head
{color:#ff7900;font-weight:700;}#yiv1640187844 #yiv1640187844ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1640187844 #yiv1640187844ygrp-sponsor
#yiv1640187844ov li a {font-size:130%;text-decoration:none;}#yiv1640187844
#yiv1640187844ygrp-sponsor #yiv1640187844ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1640187844
#yiv1640187844ygrp-sponsor #yiv1640187844ov ul {margin:0;padding:0 0 0
8px;}#yiv1640187844 #yiv1640187844ygrp-text
{font-family:Georgia;}#yiv1640187844 #yiv1640187844ygrp-text p {margin:0 0 1em
0;}#yiv1640187844 #yiv1640187844ygrp-text tt {font-size:120%;}#yiv1640187844
#yiv1640187844ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1640187844
