coba formula,
=COUNTIF(D5:D17;">="&TODAY()-7)
bila kompi setempat berigional english ganti titik koma ";" dengan koma ","
bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa
contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut,
agar member milis yang lain dapat mengerti dan dapat membantu br,
odong nando
Dari: "'Fendik Anton Wijaya' fendik.an...@tafinance.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat
Terima kasih banyak Om Odong Nando atas responnya... Betul om yang dicari
hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya
lihat karena saya ada target F5PD...Jadi F5PD itu kemampuan customer bayar
angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD
tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5
bulan... Mohon maaf om klo penjelasannya kurang jelas... 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 From: mailto:belajar-excel@yahoogroups.com Sent:
Monday, August 29, 2016 6:13 PMTo: belajar-excel@yahoogroups.com Subject: Bls:
[belajar-excel] rumus countif dengan beda kriteria bertingkat 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' fendik.an...@tafinance.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
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.
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.
�/span>Towards a Sustainable Future - Please consider the environment before
printing this email.
#yiv2159025051 #yiv2159025051 -- #yiv2159025051ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2159025051
#yiv2159025051ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2159025051
#yiv2159025051ygrp-mkp #yiv2159025051hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2159025051 #yiv2159025051ygrp-mkp #yiv2159025051ads
{margin-bottom:10px;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad
{padding:0 0;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad p
{margin:0;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad a
{color:#0000ff;text-decoration:none;}#yiv2159025051 #yiv2159025051ygrp-sponsor
#yiv2159025051ygrp-lc {font-family:Arial;}#yiv2159025051
#yiv2159025051ygrp-sponsor #yiv2159025051ygrp-lc #yiv2159025051hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2159025051
#yiv2159025051ygrp-sponsor #yiv2159025051ygrp-lc .yiv2159025051ad
{margin-bottom:10px;padding:0 0;}#yiv2159025051 #yiv2159025051actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2159025051
#yiv2159025051activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2159025051
#yiv2159025051activity span {font-weight:700;}#yiv2159025051
#yiv2159025051activity span:first-child
{text-transform:uppercase;}#yiv2159025051 #yiv2159025051activity span a
{color:#5085b6;text-decoration:none;}#yiv2159025051 #yiv2159025051activity span
span {color:#ff7900;}#yiv2159025051 #yiv2159025051activity span
.yiv2159025051underline {text-decoration:underline;}#yiv2159025051
.yiv2159025051attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2159025051 .yiv2159025051attach div a
{text-decoration:none;}#yiv2159025051 .yiv2159025051attach img
{border:none;padding-right:5px;}#yiv2159025051 .yiv2159025051attach label
{display:block;margin-bottom:5px;}#yiv2159025051 .yiv2159025051attach label a
{text-decoration:none;}#yiv2159025051 blockquote {margin:0 0 0
4px;}#yiv2159025051 .yiv2159025051bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2159025051
.yiv2159025051bold a {text-decoration:none;}#yiv2159025051 dd.yiv2159025051last
p a {font-family:Verdana;font-weight:700;}#yiv2159025051 dd.yiv2159025051last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2159025051
dd.yiv2159025051last p span.yiv2159025051yshortcuts
{margin-right:0;}#yiv2159025051 div.yiv2159025051attach-table div div a
{text-decoration:none;}#yiv2159025051 div.yiv2159025051attach-table
{width:400px;}#yiv2159025051 div.yiv2159025051file-title a, #yiv2159025051
div.yiv2159025051file-title a:active, #yiv2159025051
div.yiv2159025051file-title a:hover, #yiv2159025051 div.yiv2159025051file-title
a:visited {text-decoration:none;}#yiv2159025051 div.yiv2159025051photo-title a,
#yiv2159025051 div.yiv2159025051photo-title a:active, #yiv2159025051
div.yiv2159025051photo-title a:hover, #yiv2159025051
div.yiv2159025051photo-title a:visited {text-decoration:none;}#yiv2159025051
div#yiv2159025051ygrp-mlmsg #yiv2159025051ygrp-msg p a
span.yiv2159025051yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2159025051
.yiv2159025051green {color:#628c2a;}#yiv2159025051 .yiv2159025051MsoNormal
{margin:0 0 0 0;}#yiv2159025051 o {font-size:0;}#yiv2159025051
#yiv2159025051photos div {float:left;width:72px;}#yiv2159025051
#yiv2159025051photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2159025051
#yiv2159025051photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2159025051
#yiv2159025051reco-category {font-size:77%;}#yiv2159025051
#yiv2159025051reco-desc {font-size:77%;}#yiv2159025051 .yiv2159025051replbq
{margin:4px;}#yiv2159025051 #yiv2159025051ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2159025051 #yiv2159025051ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2159025051
#yiv2159025051ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2159025051
#yiv2159025051ygrp-mlmsg select, #yiv2159025051 input, #yiv2159025051 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2159025051
#yiv2159025051ygrp-mlmsg pre, #yiv2159025051 code {font:115%
monospace;}#yiv2159025051 #yiv2159025051ygrp-mlmsg *
{line-height:1.22em;}#yiv2159025051 #yiv2159025051ygrp-mlmsg #yiv2159025051logo
{padding-bottom:10px;}#yiv2159025051 #yiv2159025051ygrp-msg p a
{font-family:Verdana;}#yiv2159025051 #yiv2159025051ygrp-msg
p#yiv2159025051attach-count span {color:#1E66AE;font-weight:700;}#yiv2159025051
#yiv2159025051ygrp-reco #yiv2159025051reco-head
{color:#ff7900;font-weight:700;}#yiv2159025051 #yiv2159025051ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2159025051 #yiv2159025051ygrp-sponsor
#yiv2159025051ov li a {font-size:130%;text-decoration:none;}#yiv2159025051
#yiv2159025051ygrp-sponsor #yiv2159025051ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2159025051
#yiv2159025051ygrp-sponsor #yiv2159025051ov ul {margin:0;padding:0 0 0
8px;}#yiv2159025051 #yiv2159025051ygrp-text
{font-family:Georgia;}#yiv2159025051 #yiv2159025051ygrp-text p {margin:0 0 1em
0;}#yiv2159025051 #yiv2159025051ygrp-text tt {font-size:120%;}#yiv2159025051
#yiv2159025051ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2159025051
